Search for asterisk

[Andrew G]

Hello.
What criteria do I need in order to find an asterisk (*) within a field?
Andy.

 

[Joe4]

Here is an expression which will return the character position that the asterisk is found within the text string:

FindAsterisk: InStr([TextFieldName],Chr(42))

The key is that the Asterisk has an ASCII code of 42, so Chr(42) will return as asterisk, and the formula won't think you are entering in a wild card.

 

[Andrew G]

Thank you. I also found this expression works:
Like "
[*]"