String Search in Teradata CLOB


String Search in Teradata CLOB


Would you please anybody help me answering

How to perform a string search in Teradata CLOB clumns?

Thanks a lot for your help!!


Re: String Search in Teradata CLOB

The new Regular Expression functions like "REGEXP_INSTR" can search a CLOB.

The example in the Teradata documentation is:

SELECT REGEXP_INSTR('Hello Santa says ho ho', 'ho', 1, 2, 0, i);

returns the result 21.


Other regular expression functions are:

They are very interesting and powerful, but take work and time to learn.

I enjoyed reading Satyaki De's Wordpress blog (, and there are many resources to learn regular expressions.