Hi, Can any body provide some inputs on how to rewrite the below statement in oracle sql. REG_MATCH is informatica function. SELECT IIF(REG_MATCH(W_PARTY_PER_DS.X_IDENTITY_ID,'Person-.*')=1,SUBSTR(W_PARTY_PER_DS.X_IDENTITY_ID,8),NULL) FROM W_CASE_PER_DS; Thanks in advance Kumar