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-

RE: X case-insensitivity in Access

, 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

RE: X case-insensitivity in Access

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

RE: X case-insensitivity in Access

-insensitivity in Access 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