Re: case independent LIKE select?

From: Steve Dyrdahl <dyrdahl_at_nixon.reticular.com>
Date: Tue, 18 Jan 2000 09:13:27 -0800
Message-ID: <Pine.GSO.4.05.10001180912001.16989-100000@nixon.reticular.com>

Since you posted to oracle.misc I am assuming that you are using Oracle and have access to the upper function.

SELECT c1
FROM t1
WHERE UPPER(c1) LIKE 'SOMETHING IN CAPS%';

>
> I'm trying to write a search function which has the ability to perform a
> LIKE search for keywords in article titles regardless of case. I have no
> problem doing this if I specify the correct case, but no go if I don't
> enter proper capitalization. Could someone please show me the proper
> syntax to pull this off?
>
> Thanks in advance,
>
> Rich Gilmour
>
>
>
>
>
Received on Tue Jan 18 2000 - 11:13:27 CST