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