Your problem may be the use of single quotes around your wildcard search
string. I haven't tested it but SQL probably works like PHP in that single
quotes denote exact values while double quotes allows evaluation of the
quoted string.
-Kevin
Robin S McKenzie [EMAIL PROTECTED] wrote in message
. :-)
-Original Message-
From: Kevin Stone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 4:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Using functions in SELECT statements
Your problem may be the use of single quotes around your wildcard search
string. I haven't tested
(in response to my own response)
By the way it just occured to me that the default SELECT statement is
already case insensitive. So is any of this is even necessary? If you want
to display the selected items in lower case, then do that in your script
with strtolower();
-Kevin
Robin S McKenzie