case-insensitive lookups...

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                       *
     __________________________________________________________________