Hi. Apologies for my bad.
SELECT * FROM People WHERE LName LIKE "%off%"
DOES return Hoffman and Offman.
How can I search for "Hoffman" with "hoff"?
ie: SELECT * FROM People WHERE LName like "%hoff%"
Doesn't return Hoffman.
Any ideas?
Thanks,
Nick Hoffman
> -----Original Message-----
> From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]]
> Sent: August 9, 2002 6: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