Non case sensitive

From: "roy simkes" <roysimkes(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Non case sensitive
Date: 2006-08-14 12:57:39
Message-ID: BAY108-W8FF2CF6F80C48E478F8AFA14E0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is there a way that select's where clause can be used as insensitive to the case? I mean:
"SELECT * FROM table WHERE field LIKE 'f' " will return every row that field begins with a "f" or a "F". Without writing " field LIKE 'f' OR field LIKE 'F' " of course.

Thanks
_________________________________________________________________
Try Live.com - your fast, personalized homepage with all the things you care about in one place.
http://www.live.com/getstarted

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Shoaib Mir 2006-08-14 13:04:37 Re: Non case sensitive
Previous Message Sean Davis 2006-08-14 12:51:09 Re: can someone tell me what's wrong with this procedure?