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

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.

....
WHERE UPPER(theColumn) LIKE '%'||UPPER(:thingUserTyped)||'%'

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||