Archives of the TeradataForum
Message Posted: Wed, 14 Sep 2005 @ 20:53:37 GMT
I need to convert a piece of DB2 code to Teradata. The code is something like this:
CASE WHEN TRANSLATE(RTRIM(LTRIM( SUBSTR(COL_1,1,6) )),'$',' 0123456789') = '' THEN INTEGER(SUBSTR(COL_1,1,6)) ELSE CAST(NULL as INTEGER) END AS DISP_COL_1
What does the TRANSLATE on DB2 do ?. What would be the Teradata equivalent for this ?.
Sorry, this may be very basic, but I cannot understand what the TRANSLATE on DB2 does to look for a solution on Teradata.
Thanks in advance !
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|