ODBC MS-Access and LIKE Clause

admin

Administrator
Staff member
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 --><a href="mailto:[email protected]">[email protected]</a><!-- e -->

Thanks,

Steve
 
Back
Top