It seems easy but I'm missing something. I have a MySQL database that is connected from access through ODBC connector.
I'm looking for the fields where there are # symbol but I'm getting zero results, although I have a field with # (Access query).
id obs 1 #rejected
Access Query where I do not have any results
SELECT id, obs FROM Person WHERE obs Like '*#*'
+info added from answers
MySQL Query works fine
SELECT id, obs FROM Person WHERE obs Like '%#%' SELECT id, obs FROM Person WHERE obs LOCATE('#',obs) >0
Which is the escape character in Access? Any ideas to fix Access query?