On Wed, 2007-03-28 at 12:27 +0530, Lloyd K L 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 "My table" WHERE name LIKE '%ab%' ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------