Re: Using functions in SELECT statements

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