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 PROTECTE
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:
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, 200