Hello guys,

I have a varchar column in my database and i would like to replace before the values “SU” in vendor table. I try to use the function INSTR but its not working in OCPM.

Kindly please let me know  what is the function to be used to remove before values for SU.

Few are the examples below : 

GHYSU1000104933

1000SU1000143290

22SU1000003141