Hey. I'm using an Access2000 DB. I have the following information in a table
called People:
        Jones
        Hoffman
        Offman
        Smith

How can I select everything that contains "off", regardless of
capitalization? (ie: select Hoffman and Offman with just "off")

The following returns Hoffman but not Offman:
        SELECT * FROM People WHERE LName LIKE "%off%"

So, is there a switch in SQL that compares thte search criteria to the data
case-insensitively?

Thanks for your help!
        Nick Hoffman

Reply via email to