Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help! Case Insensitivity with SELECT..WHERE..LIKE queries

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

From: <drippel_at_perspect.com>
Date: 1997/08/28
Message-ID: <3405f3c8.31669318@news.erols.com>#1/1

You will probably need to convert everything to upper or lower to make the comparison.

On Thu, 28 Aug 1997 13:19:06 -0700, "Eric B. Vest" <evest_at_vest.com> 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
>
Received on Thu Aug 28 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US