Re: case insensitive query?
From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Wed, 25 Apr 2001 12:43:07 GMT
Message-ID: <3AE6C587.57181E9_at_cgi.ca>
Date: Wed, 25 Apr 2001 12:43:07 GMT
Message-ID: <3AE6C587.57181E9_at_cgi.ca>
Hi Bart,
What about:
SELECT NAME
FROM ADDRESS
WHERE LOWER (NAME) LIKE '%bart%';
Bart Vandewoestyne wrote:
> If i do the following query:
>
> SELECT NAME
> FROM ADDRES
> WHERE NAME LIKE '%Bart%'
>
> Then I only will get the results that match case sensitive with my
> search criterium. So only the Bart's with capital B will appear.
>
> If I also want names containing '%bart%', then how should I write my
> query?
>
> The question is: how do I do a case insensitive query?
>
> Greetzzz,
> mc303
>
> --
> !!! MY EMAIL HAS CHANGED !!! IT IS NOW:
>
> ====>> Bart.Vandewoestyne_at_pandora.be <<===
> ---
Received on Wed Apr 25 2001 - 14:43:07 CEST