Selecting conditional CLOB's - SQL HELP!

Have Oracle 8 databases, using a CLOB field to store text. Want to run:

Select ID, BLOB from TABLE where BLOB LIKE '%HELLO%'

Using Delphi6SP2 and OCI8

Thanx in advance!

MK