Case insensitive records search

[Andis Grasis]

Hi!

I have such SQL :

select CompanyName from Company where CompanyName like '%car%'

Really I need in query result all of companys, which contains symbols CAR in any case 
(car, Car,CAr, CAR, e.t.c).
I think that I need Case insensitive records search.

Is it's possible and how?

Thanks a lot!

Andis