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@fallon.classyad.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! _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_