Postgres Pro
Downloads
Home   >   mailing lists

How to Make Case InSensitive??? - Mailing list pgsql-sql

From S.Ramaswamy
Subject How to Make Case InSensitive???
Date
Msg-id 35EC1A87.A9943@giasdl01.vsnl.net.in
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Johann Spies
Date:
Subject: pgaccess-forms.
Next
From: David Hartwig
Date:
Subject: Re: [SQL] How to Make Case InSensitive???