Oracle and Clob in where clause

Hi, i have a big problem with CLOBs on Oracle. I'm migrating from a mysql data base and one of my field was a TEXT field (I need to have text of 50Ko). Then, while varchar doesn't pass the oracle wall of 4000 octect, i'm using clob. I find out how to use those Clobs field, to insert, update, and select them (and over the 4000 octect wall) but, i can't make a search on them ! for exemple, those doesn't work : select clobvalue from test where clobvalue='Hello World' or select clobvalue from test where clobvalue like '%Hello%' Some one have an idea ? Thanx, ___________ Wilfrid Brown Directeur DigiFactory Tel : 01 40 21 08 84 Fax : 01 40 21 08 97 GSM : 06 63 05 72 33 mailto:wilfrid@digifactory.fr / http://www.digifactory.fr