Thread: LIKE operator on CLOB column
11-26-09, 02:23 #1Registered User
- Join Date
- Jun 2009
Unanswered: LIKE operator on CLOB column
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%'
select * from TESTTABLE where TESTTABLE.text like 'sss%'