Re: Like operator with accented character
- From: "John" <John@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 23 Jan 2006 00:00:13 -0000
Hi John
The accented characters are being included in this filter without being
there. My problem is why they are being treated as being included in the
filter while I have not included them in this filter.
Thanks
Regards
"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:vlv7t1lue44fi44kuu9gobroo04a78hs5b@xxxxxxxxxx
> On Sun, 22 Jan 2006 20:57:34 -0000, "John" <John@xxxxxxxxxxxxxxxxxxxx>
> wrote:
>
>>Hi
>>
>>I am using Like "*[!-!0-9A-Z &,.@/'():+]*" in my select query to exclude
>>all
>>characters listed but the query also excludes accented characters? Is
>>there
>>a way that accented characters are not included in this filter?
>
> Yes. The ASCII value for accented characters is is different than the
> non-accented characters: é is 233, e is 65.
>
> I'm not certain how the LIKE operator handles upper vs. lower case (e
> and E are different ASCII values as well), but try
>
> Like "*[!-!0-9A-ZÀ-Ý &,.@/'():+]*"
>
> You may want to use some VBA code to include the characters you want
> to include, rather than excluding the thousands of possible Unicode
> characters that might get typed by imaginative users. Så?ï?fæç?ò?ÿ?
>
> John W. Vinson[MVP]
.
- References:
- Like operator with accented character
- From: John
- Re: Like operator with accented character
- From: John Vinson
- Like operator with accented character
- Prev by Date: Re: Show remaining balance in same query
- Next by Date: Re: Add to rows in the same table with query?
- Previous by thread: Re: Like operator with accented character
- Next by thread: Re: Like operator with accented character
- Index(es):
Relevant Pages
|
