RE: [PHP-DB] Re: Using functions in SELECT statements

Is this in SQL server? It seems we don't have enough of the code to be able to tell the problem. The query has to be put in a string and SearchBox has to exist, and this all has to be run from a query function, and .... well, if you actually show your php code it would help quite a bit. :-) -----Original Message----- From: Kevin Stone [mailto:kevin@helpelf.com] Sent: Thursday, May 02, 2002 4:44 PM To: php-db@lists.php.net 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 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" <Robin.McKenzie.98@bristol.ac.uk> wrote in message news:20020502133403.39864.qmail@pb1.pair.com... > > I'm trying perform a case-insensitive test for a name. These are stored > like "Association of ...", and I want to convert both the filter and the > test data to lower- (or upper-) case. Why doesn't this work: ? > > SELECT * > FROM [Organisation Membership] > WHERE lower(organisation) LIKE lower('%$SearchBox$%') > > Robin McKenzie > Department of Mechanical Engineering > University of Bristol > e:Robin.McKenzie.98@bris.ac.uk > e:robin@finevinyl.co.uk > m:+44(0)7970 058712 > ________________________________ > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php