Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Non case sensitive

  • From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
  • To: roy simkes <roysimkes(at)hotmail(dot)com>, <pgsql-novice(at)postgresql(dot)org>
  • Subject: Re: Non case sensitive
  • Date: Mon, 14 Aug 2006 09:12:58 -0400
  • Message-id: <C105EF1A(dot)F43D%sdavis2(at)mail(dot)nih(dot)gov>


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
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group