Postgres Pro
Downloads
Home   >   mailing lists

Non case sensitive - Mailing list pgsql-novice

From roy simkes
Subject Non case sensitive
Date
Msg-id BAY108-W8FF2CF6F80C48E478F8AFA14E0@phx.gbl
Whole thread Raw
Responses Re: Non case sensitive  ("Shoaib Mir" <shoaibmir@gmail.com>)
Re: Non case sensitive  (Sean Davis <sdavis2@mail.nih.gov>)
Re: Non case sensitive  (Brendon Gleeson <brendon@gleesonprop.co.za>)
List pgsql-novice
Tree view
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

Express yourself instantly with Windows Live Messenger! Windows Live Messenger!

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: can someone tell me what's wrong with this procedure?
Next
From: "Shoaib Mir"
Date:
Subject: Re: Non case sensitive