MS Access criteria with like function

Hi there,

I am working with MS Access for setting criteria for a Text field. Would like to find a "*" if it occuried inside the text by LIKE function. However I found as the original setting of Like * means match all, I fail to do what I need :

e.g. original MS Access setting is : to find text contains "A" is LIKE "*A*"

However, what I need now is to find text contains "*"...........

Pls anybody help?
hkgalAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
If the field contains just an asterisk then set the criteria as
"[*]"

If the field contains other characters as well as an asterisk then use..

Like "*[*]*"
0
 
Rgonzo1971Commented:
Hi

Like "[*]"

Regards
0
 
hkgalAuthor Commented:
thanks excellent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.