If only it were that simple - sorry, that was a copying error...
It gives the error " undefined function: lower" R Robin McKenzie Department of Mechanical Engineering University of Bristol e:[EMAIL PROTECTED] e:[EMAIL PROTECTED] m:+44(0)7970 058712 ________________________________ "Peter Lovatt" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > Could it be the second $ in the lower('%$SearchBox$%') ? > > Peter > > > > ----------------------------------------------- > Excellence in internet and open source software > ----------------------------------------------- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > ----------------------------------------------- > > > -----Original Message----- > > From: Robin S McKenzie [mailto:[EMAIL PROTECTED]] > > Sent: 02 May 2002 14:34 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Using functions in SELECT statements > > > > > > > > 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:[EMAIL PROTECTED] > > e:[EMAIL PROTECTED] > > m:+44(0)7970 058712 > > ________________________________ > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php