"P Kishor" <[EMAIL PROTECTED]> wrote: > On 3/28/07, Lloyd K L <[EMAIL PROTECTED]> wrote: > > Hi, > > My table contains a text field called Name. Let the data be > > > > Name > > ------- > > Abc > > abcd > > AB > > cab > > def > > > > I want to selcct all the rows which contains the term ab (not case > > sensitive). How can I do this? > > > > SELECT name FROM table WHERE Lower(name) LIKE '%ab%'l >
This works, but the lower() is redundant. LIKE is already case insensitive. So just "... WHERE name LIKE '%ab%'" should get the job done. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------