Convert LONG to a string

I have an 9i database on Windows 2003 with some mutli-line text stored in a LONG field. I want to seatch this LONG field with a string.

SQL> desc multiline_text;

ENTITY_DBID	                NUMBER(10)
ENTITY_FIELDDEF_ID	NUMBER(10)
DATA	                                LONG

SQL> select multiline_text.data
from multiline_text
where cast(multiline_text.data AS VARCHAR2(132)) like '%Done.' ;

ORA-00932: inconsistent datatypes

How can I convert LONG to a searchable string?

TIA Received on Wed May 17 2006 - 12:54:58 CDT