Hello,

Suppose I have table TESTTABLE with columns id(INT8 PK), clob(CLOB), text(TEXT)

Is there any way to use LIKE operator on these columns?

select * from TESTTABLE where TESTTABLE.clob like 'sss%'
or
select * from TESTTABLE where TESTTABLE.text like 'sss%'