Hi

Thanks for the updates. I've managed to get your code working.

My result is gets the same column output as yours, but no data

I Just added your datavalue to the RUG_CLOB Table DATA column, with arbitrary index1 of 1

I think its failing to pick up the DATA value because of this line

CAST(DATA AS VARCHAR(MAX)) LIKE 'ZHV|FS0000%%%|D0003001%'