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

[Guest]

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.

 

[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.

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]

 

[Guest]

Thanks so much.

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.

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]