Thread: case-insensitive lookups...

case-insensitive lookups...

From
Lorenzo Huerta
Date:
is there a way to do selects /etc on fields without regard to upper/lower
case of the data in the fields?


Thanks,

     __________________________________________________________________
     *  Lorenzo J. Huerta                                             *
     *  Programming Assistant                                         *
     *  Computing & Networking Networking Architecture and Operations *
     *  New Mexico State University                                   *
     *  phone: (w)(505)646-2582 (h)(505) 521-8699 fax:(505) 646-8139  *
     *  e-mail: lorenzo@nmsu.edu                                      *
     *  Web Site: http://web.nmsu.edu/~ljhuerta                       *
     __________________________________________________________________


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

From
Marc Howard Zuckman
Date:
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!                      _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_