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