Help with LIKE operator

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 Received on Thu Jul 16 1998 - 08:15:00 CDT