I'm trying to do a fuzzy search on two fields from two textboxes.
It looks something like this:
"SELECT [fields] FROM [table] WHERE [field1] LIKE '%'+textbox1.value+'%'
AND
[field2] LIKE '%'+textbox2.value+'%' ORDER BY [fields] INTO CURSOR"
I get an error when I try to save if I don't remove one of the '%' in the
middle. Is there a fix for my syntax or do I need to do a workaround?
Thanks,
Jim