Re: Would like to do .... LIKE '%fred%' on LONG column

From: Georg Verweyen <georg.verweyen_at_t-mobil.de>
Date: Wed, 21 Oct 1998 11:26:37 +0200
Message-ID: <362DA8CD.5AFF@t-mobil.de>

Paul Smith wrote:
>
> I would like to add a where clause to a select on a long column, but ..

See SQL Language Reference Manual Page 3-7

        char1 [NOT] LIKE char2

char1 is a value to be compared with a pattern. This value can

       have datatype CHAR or VARCHAR2.
char2 is the pattern to which char1 is compared. ...

---

Georg Verweyen
Disclaimer: The opinions expressed here are my own and not of the company I am working for. Received on Wed Oct 21 1998 - 04:26:37 CDT