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

Reply via email to