(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" <[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
