Somebody help me with the sql or pl/sql statement to query the long data type.

I have the table tab1. with the following columns as follows.

col1 number;
col2 long;


I want to do the following.

select col1, col2
from tab1
where col2 like '%string Pattern%';

The above statement is giving me the ORA-00932 error.

I know that the oracle long datatype connot be used in the where clause, is there any other way to do this. I am sure some one have done this already. help please.

Example:

select t$item,to_char(t$oqmf) from ttiitm001100
where t$oqmf > 1 and rownum < 20
and to_char(t$oqmf) like '%25%'


regards

Richard,

Its the LOBs( Large Objects) in Oracle, not the long data type in baan.