I am trying to avoid (or somehow convert to string) wildcard characters in my query for example (only end of query):
WHERE searchstring LIKE '% 123_ %'
is it possible to somehow sql treat 123_ as string and not to treat character _ as wildcard.
I am using:
sSql = sSql + " AND user LIKE '%" & Text1.Text & "%'"
now when in Text1.Text is found square bracket character [ it produces error, how can I solve this problem?