select like %xyz% in a CLOB???

Hi!
I would like to do this:
select * from table where longtext like '%hello%';

In a vchar2 field it works perfect...in a "long" or clob filed it dosenīt. How can i do that?

I spent many many hours, but couldīnt find a good solution.

How can i do this....i read something about indexes and Intermedia...

but is this the only (and easy) way?

 Thanks for any help!!!!

Andre Received on Fri Jan 11 2002 - 13:30:50 CST