Re: Help! Case Insensitivity with SELECT..WHERE..LIKE queries

From: Oleg <oleg_at_stat.ee>
Date: 1997/09/04
Message-ID: <340EB183.2E063EB0@stat.ee>#1/1

Eric B. Vest wrote:

> Help, anybody:
>
> I'm trying to run a SELECT...WHERE...LIKE query on product names and
> descriptions. However, I don't know of a way to ensure that the search
> is case-insensitive, as the LIKE conditions are dependent on user
> input. I need to make sure that the program returns a positive search
> result when a user types in "malaysia" even if "Malaysia" is the actual
> entry in the database.
>
> I'd humbly appreciate any assistance. Thanks.
>
> -- Nathan
> ..................................................
> Vest Technologies
> http://www.vest.com
> 350 Bay Street
> Suite 100-123
> San Francisco, CA 94133
> 415/986-VEST
That's to easy: use Upper lower clause. Oleg Received on Thu Sep 04 1997 - 00:00:00 CDT