ODBC MS-Access and LIKE Clause

[stevenszabo]

I'd like help with the following issue. The SQL statment below works fine when I copy and paste it into MS-Access. From PHP4/ODBC, ZERO records are returned. The "LIKE" clause appears not to work from PHP4/ODBC.

SELECT Id, Title, FirstName, MiddleInitial, LastName, PrimaryEmailAddress FROM People WHERE ((FirstName LIKE 'bo') OR (LastName LIKE 'bo')) ORDER BY LastName

Any ideas?

Please email me at [e-mail]

Thanks,

Steve

[kparker]

My ODBC manual states:

   In a LIKE predicate, the percent sign (%) matches zero
   or more of any character and the underscore(_) matches
   any one character.

One possible explanation is that MS Access, when directly connected to an MDB file and thus using the Jet database engine, simply uses '*' in place of '%'. Or it could be that the Access user interface is making the switch for you. Ya gotta love Microsoft, though--they don't even follow their own standards!

[stevenszabo]

Thank you, the percent sign works !