Dewey, I believe that the % wildcard is ANSI SQL requirement. I know at least Oracle, MS SQL Server, & Sybase use it.
-Masroor -----Original Message----- From: Williams, Dewey [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 4:08 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access !! SOLVED It seems the use of LIKE in an sql statement requires the 'wild-card' % instead of * when sending to an Access (and other?) databases. If anyone knows WHY, I would like an explanation. Dewey Williams [EMAIL PROTECTED] -----Original Message----- From: Williams, Dewey [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 3:59 PM To: [EMAIL PROTECTED] Subject: [PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access HELP! I need the WHERE statement to use LIKE and wrap the variable $ProdVar in * so users can do a text search on the field. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
