Using LIKE with a LONG field

I'm trying to search through a LONG field which contains the description of an item in my database. However, when I use the following SQL Query I am told that I have 'inconsistant datatypes' when I run the Query (in ASP)

SELECT * FROM resources_objects WHERE resource_object_description LIKE '%string%'

Any idea how I can use LIKE with a LONG field? I'm pretty certain it's this LONG field type that's caussing the issue, as the same SQL Query with a different field type (VARCHAR2) works fine. Received on Tue Aug 20 2002 - 15:40:03 CDT