How to Make Case InSensitive???

When I use SQL statements, how can I make it case insensitive. If I
use

    SELECT * FROM series WHERE NAME='India'

I want to select rows including those where NAME='INDIA' / NAME =
'india'
and so on.

Can someone help me in the above??

Regards

S.Ramaswamy