Hello all,
Does anyone know how to search for wildcard character in the search dialog?
We have data that looks like this:
XXX_YYYYYYYY
XXX_zzzzzzzzz
XXXXX_YYYYYY
XXXXX_zzzzzzzzz
and we want to see only the top 2 results.
WHERE field LIKE 'XXX!_%' ESCAPE '!'
This can be used in the sql-query, but sql-query is not available in all masks.
Thanks for the help!
As far as I can tell, underscore is not open to interpretation within the normal search dialogues
i.e. there is no escape option. It always means ‘any character’.
Your solution of using the SQL Where Expression Tab is probably the only way to do it.
Hi
you can use an underscore for exactly one character in the IEE search dialogue.
Use percent sign for any characters or string (0 to n). ESCAPE isn’t possible there like
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.