ID: 9015 Updated by: phanto Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: ODBC related Assigned To: Comments: the wildcard for sql is % not * . reopen if i misunderstood you. harald. Previous Comments: --------------------------------------------------------------------------- [2001-01-30 18:05:49] [EMAIL PROTECTED] The following SQL statements do not lead to any selection. But direct tests via MS-ACCESS showed the correctness of the SQL statements. Example code: .. $PARAMETER = "XYZ*"; $QUERY = "SELECT ... WHERE ((Table.Row) LIKE '$PARAMETER') ....."; ... $RESULT = odbc_exec ($DB, $QUERY); does not work (no results from odbc_exec). If I use "XYZ" instead of "XYZ*", I get at least one result for the string "XYZ". Who swallows or changes the *-sign? --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=9015 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]