this SQL works perfectly for finding numerics:
this SQL fails due to "Argument 2 of function TRANSLATE not valid." with the preceding message "CPD4318-Derived operands not valid for operator Reason code 14. 14 -- Operand number two is not valid for the operation."
can someone help me figure out my boneheaded mistake? i'm sure i'm missing something simple or i'm losing my mind, not sure which at this point!
PHP Code:
select TRANSLATE(cuno, ' ', '0123456789,.# ' ),cuno
FROM tmccd42.arcreditassignments​
PHP Code:
select TRANSLATE(right(trim(h.doccode),2), ' ', '0123456789,.# ' )
from codad42dta.oas_dochead h​
Comment