I tried to convert a netezza code to Teradata. Just wanted to confirm, if I have done it correclty.
NZ: LTRIM(TRANSLATE(PHONE_NBR,' (',''),'1 ')
TD: TRIM (LEADING '1' FROM LCI_UD_FUNCTION.OTRANSLATE(PS_PRO.PRIM_PHONE_NBR,' (',' '))
As per my research in NZ, Translate & LTRIM functions replaces characters not a whole string. So, not sure if the TD code will work as expected.