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 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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