Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 20:53:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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 !

Raghav Vaidya

	<Prev	Next>		<<First	<Prev	Next>	Last>>