Re: Using functions in SELECT statements

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