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
