Can I filter records containing an asterik '*' in it.

M

mah

I was trying to use a filter to get all records containing an '*' in it.
For example, PPKN0*012, PPKI0*022, EEK1*012 etc. I tried using ***, *"*"*,
*'*'* and not working. How do I use the filter for this? Appreciate for your
help.
 
J

John W. Vinson

I was trying to use a filter to get all records containing an '*' in it.
For example, PPKN0*012, PPKI0*022, EEK1*012 etc. I tried using ***, *"*"*,
*'*'* and not working. How do I use the filter for this? Appreciate for your
help.
Click to expand...

You can wrap wildcard or other special characters in square brackets to make
them be taken literally:

LIKE "*[*]*"

will find any string of characters (the first asterisk), followed by a literal
asterisk, followed by any other string of characters.

John W. Vinson [MVP]
 
M

mah

Thanks so much.

John W. Vinson said:
I was trying to use a filter to get all records containing an '*' in it.
For example, PPKN0*012, PPKI0*022, EEK1*012 etc. I tried using ***, *"*"*,
*'*'* and not working. How do I use the filter for this? Appreciate for your
help.
Click to expand...

You can wrap wildcard or other special characters in square brackets to make
them be taken literally:

LIKE "*[*]*"

will find any string of characters (the first asterisk), followed by a literal
asterisk, followed by any other string of characters.

John W. Vinson [MVP]
Click to expand...
 
Top