Szabo Zoltan <[EMAIL PROTECTED]> writes:
> Use: ILIKE
>
> > If I am doing a command such as
> > select * from Apples where color like '%red%';
> > how do I make it case insensitive?
I was trying to solve a similar problem where I wanted an exact match to work
in PostgreSQL and MySQL and ended up with:
lower(Field) = lower('string')
Is there another way that works on both?
--
matthew rice <[EMAIL PROTECTED]> starnix inc.
tollfree: 1-87-pro-linux thornhill, ontario, canada
http://www.starnix.com professional linux services & products
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
