murgatroyd
Registered User.
- Local time
- Today, 13:09
- Joined
- Mar 26, 2016
- Messages
- 31
I am trying to create a query that will find records where a "CustomerName" field contains any invalid characters.
Valid characters are (1) space, (2) hyphen, (3) apostrophe, (4) "Basic Latin" (English) letters (Aa-Zz), and (5) "Latin-1 Supplement" (other European) letters (À-ÿ = extended ASCII values 192-255). I know how to include the first four items in the query criteria, but how do I include the last one?
Using
works for single ASCII values, but how do I specify a range of values?
I tried using
but it did not work.
Valid characters are (1) space, (2) hyphen, (3) apostrophe, (4) "Basic Latin" (English) letters (Aa-Zz), and (5) "Latin-1 Supplement" (other European) letters (À-ÿ = extended ASCII values 192-255). I know how to include the first four items in the query criteria, but how do I include the last one?
Using
Code:
Like "*[" & Chr(192) & "*]"
I tried using
Code:
Like "*[" & Chr(192) & "-" & Chr(255) & "*]"
Last edited: