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?
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?
Who is Participating?
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.
-
Course of the Month6 days, 5 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
"[*]"
If the field contains other characters as well as an asterisk then use..
Like "*[*]*"