case insensitive query?
From: Bart Vandewoestyne <Bart.Vandewoestyne_at_pandora.be>
Date: Tue, 24 Apr 2001 23:39:27 +0200
Message-ID: <3AE5F28F.F79C25FA_at_pandora.be>
Date: Tue, 24 Apr 2001 23:39:27 +0200
Message-ID: <3AE5F28F.F79C25FA_at_pandora.be>
If i do the following query:
SELECT NAME
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,
FROM ADDRES
WHERE NAME LIKE '%Bart%'
mc303
--
!!! MY EMAIL HAS CHANGED !!! IT IS NOW:
====>> Bart.Vandewoestyne_at_pandora.be <<===
---
Received on Tue Apr 24 2001 - 23:39:27 CEST