You could use the ~* operator. That will do a Case Insensitive
comparison. If you go to the website
(http://www.postgresql.org/users-lounge/docs/7.0/user/) and checkout
chapter 4, you can get a good list of the operators in posgres.
At 10/3/2000 12:41 PM, you wrote:
>Hi. LIKE does case sensitive string matching. Is there an easy way to do case
>insensitive string matching?
>
>Bob Kernell
>Research Scientist
>AS&M
>email: kernell(at)sundog(dot)larc(dot)nasa(dot)gov
--------------------------------
Doug Budny
IT - System Administrator
Due Diligence Inc.
http://www.diligence.com
Phone: (406) 728-0001
Fax: (406) 728-0006