Attempting to query MS Access database with the ODBC drivers for PHP. When
using the LIKE statement no records are returned.
Example:
$query = " Select * From Dispatch Where Customer Like '*A*' ";
$result = odbc_prepare($d b,$query);
odbc_execute($r esult);
Does anyone out there know the syntax that I should be using for the Like
statement in the Where clause? When I do a normal query, it works
fine....Just using wildcards it does not work....
using the LIKE statement no records are returned.
Example:
$query = " Select * From Dispatch Where Customer Like '*A*' ";
$result = odbc_prepare($d b,$query);
odbc_execute($r esult);
Does anyone out there know the syntax that I should be using for the Like
statement in the Where clause? When I do a normal query, it works
fine....Just using wildcards it does not work....
Comment