Skip to Content
0
Former Member
Jun 12, 2016 at 05:20 AM

Search using regular expression over CLOB/NCLOB datatype

322 Views

Hi Team,

As you guys know regular expression is available in hana now, which is very powerful feature for search. Is there a way to search using regular expression over CLOB or NCLOB datatype? i know in Hana documentation it is mentioned that regular expression doesn't support search over CLOB or NCLOB, but is there a way to cast it or some other format where i can use it?

Your help is highly appreciated.

Thanks,

Akshay