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