RE: case-insensitivity in Access

[Guidarelli, John]

Hi Nick,

Try something like this:

  SELECT *
  FROM   people
  WHERE  UPPER(lname) LIKE '%OFF%';

Good luck.

-John

-----Original Message-----
From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 3:06 PM
To: DBI-Users
Subject: case-insensitivity in Access


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