 |
 |
Archives of the TeradataForum
Message Posted: Thu, 15 Sep 2005 @ 18:17:15 GMT
| Subj: | | Re: Teradata equivalent of DB2 TRANSLATE |
| |
| From: | | Dieter Noeth |
Geoffrey Rommel wrote:
| | There you will find that TRANSLATE translates any characters to any other. There is no direct Teradata equivalent for this; you would have
to code a UDF. In this case, however, the code seems to be testing for whether the character string represents an integer, so maybe a UDF that
tested for an integer-like character string would be better. | |
Dennis Calkins once posted a UDF to check for numerics:
www.teradataforum.com/teradata/20031203_102414.htm
And the Oracle version of translate can be found at the Teradata site (but be aware, that the order of parameters is different)
Dieter
| |
