case insensitive query?

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 <<===


---