Problem: SQL syntax for LIKE statement uses the characters: % and _
Solution or Workaround
Getting syntax errors or a blank table when attempting wildcard character searches using the LIKE SQL statement.
The LIKE statement needs to be used as part of the WHERE clause. Use the percent sign ( % ) for a global wildcard character and the underscore ( _ ) for a single character wildcard.
Consider a table called 'Categories' and a Field called 'CategoryID'. To find a particular record that contains, for example, the word 'seafood'. Use the following syntax in the SQL Connect dialog box:
where: Categories.CategoryID like 'Sea%'
where: Categories.CategoryID like 'Seafoo_'
Do not use the asterik ( * ) as the global wildcard character, the question mark ( ? ) as a single character wildcard, or the pound sign ( # ) as a single character wildcard. They do not give correct results in the LIKE statement.