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
