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
