search for "*" character

[supernova122]

I want to search a field which might contain "*" character by using a query. I understand that "*" is using as wildcard and therefore I cannot input "*" directly in the criteria in a query. How can I input "*" as a search criteria in a query? I am using Access 2003. Please advise. Thanks.

[RuralGuy]

Have you tried using Chr(42)?

[kevsparky]

You need to escape the asterisk. To do so, just enclose it in square brackets.

To find an asterisk at the start of a string use: If myString Like "[*]*" Then
To find a string containing just an asterisk use: If myString Like "[*]" Then
To find an asterisk anywhere in a string use: If myString Like "*[*]*" Then

That's VBA Code, to use it in a query just take the Like "*[*]*" and put that in the criteria part of the query