Re: [SQL] case-insensitive lookups...

On Mon, 13 Jul 1998, Lorenzo Huerta wrote:

>
> is there a way to do selects /etc on fields without regard to upper/lower
> case of the data in the fields?

select * from tablename where attribute ~* 'stringvalue' ;
^^ the case insensitive regex
equality operator.

Marc Zuckman
marc(at)fallon(dot)classyad(dot)com

_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
_ Visit The Home and Condo MarketPlace _
_ http://www.ClassyAd.com _
_ _
_ FREE basic property listings/advertisements and searches. _
_ _
_ Try our premium, yet inexpensive services for a real _
_ selling or buying edge! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_