Archives of the TeradataForum
Message Posted: Thu, 15 Sep 2005 @ 17:34:05 GMT
| Subj: | | Re: Teradata equivalent of DB2 TRANSLATE |
| |
| From: | | Geoffrey Rommel |
| | What does the TRANSLATE on DB2 do? What would be the Teradata equivalent for this? | |
The DB2 manuals are available at
www.publib.boulder.ibm.com
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.
| 
