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(at)mail(dot)nih(dot)gov> To: roysimkes(at)hotmail(dot)com; pgsql-novice(at)postgresql(dot)org> > > > > On 8/14/06 8:57 AM, "roy simkes" <roysimkes(at)hotmail(dot)com> wrote:> > > 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.> > 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