S.Ramaswamy wrote:
> 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??
SELECT * FROM series WHERE upper(NAME) = 'INDIA'
or
SELECT * FROM series WHERE NAME ~* '^india$'