Re: Help with LIKE operator

From the docs (Oracle7 Server SQL Reference Manual ) ... " LONG columns cannot appear in certain parts of SQL statements: WHERE, GROUP BY, ORDER BY, or CONNECT BY clauses or with the DISTINCT operator in SELECT statements"

You are trying to use it in a WHERE clause in direct violation of the rule above.

On Thu, 16 Jul 1998 13:15:00 GMT, mark.k.lamb_at_jpl.nasa.gov wrote:

>How can I accomplish pattern-matching on LONG or CLOB datatype fields.
>
>for example:
>SELECT * FROM table
>WHERE long_datatype_column LIKE '%TEXT%'
>
>When I try this I get an inconsistent datatypes error.
>
>Mark
>

MarK Z, 6b, rhymingly Received on Fri Jul 17 1998 - 12:41:37 CDT