Re: Non case sensitive
This is a discussion on Re: Non case sensitive within the pgsql Novice forums, part of the PostgreSQL category; --> That's it!!! Thanks! > Date: Mon, 14 Aug 2006 09:12:58 -0400> Subject: Re: [NOVICE] Non case sensitive> From: sdavis2@mail.nih.gov ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 11:06 PM
| ||||
| ||||
 Re: Non case sensitive That's it!!! Thanks! > Date: Mon, 14 Aug 2006 09:12:58 -0400> Subject: Re: [NOVICE] Non case sensitive> From: sdavis2@mail.nih.gov> To: roysimkes@hotmail.com; pgsql-novice@postgresql.org> > > > > On 8/14/06 8:57 AM, "roy simkes" <roysimkes@hotmail.com> wrote:> > > Is there a way that select's where clause can be used asinsensitive 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.> > Use ILIKE instead of LIKE?> > Sean> > > ---------------------------(end of broadcast)---------------------------> TIP 5: don't forget to increase your free space map settings __________________________________________________ _______________ Try Live.com: where your online world comes together - with news, sports, weather, and much more. http://www.live.com/getstarted      |
Linear Mode
