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

From: Ian Hughes <ian.hughes_at_capgemini.co.uk>
Date: Wed, 21 Oct 1998 14:19:53 +0100
Message-ID: <362DDF78.8C3EC036@capgemini.co.uk>

You can't do this with LONGs in v7 - you can't actually do much with LONGS in v7.

Georg Verweyen wrote:

> 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 - 08:19:53 CDT