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?
"[*]"
If the field contains other characters as well as an asterisk then use..
Like "*[*]*"