What about matching 'hoff' in the middle? Such as:
Smith-Hoffman
Thanks,
Nick
> -----Original Message-----
> From: Shah, Urmil [mailto:[EMAIL PROTECTED]]
> Sent: August 9, 2002 6:24 PM
> To: '[EMAIL PROTECTED]'; DBI-Users
> Subject: RE: X case-insensitivity in Access
>
>
> Try
>
> SELECT * FROM People WHERE LName like 'hoff%'
>
> no % before hoff ( assuming it starts with hoffman, hoffroy,
> hoffsomething,
> hoffanything..) and use single quotes
> it shuld match.
>
> urmil
>
> -----Original Message-----
> From: Nick Hoffman [UWO] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 09, 2002 5:18 PM
> To: DBI-Users
> Subject: X case-insensitivity in Access
>
>
> 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