 |
 |
Archives of the TeradataForum
Message Posted: Wed, 29 May 2013 @ 15:40:35 GMT
| Subj: | | Re: BYTE Conversion to DECIMAL(18)? |
| |
| From: | | Geoffrey Rommel |
| | I need to convert up to a 20 character alphanumeric value to a numeric 18 digit number. | |
As you know, Teradata SQL has a limitation that (in most cases) BYTE cannot be converted to any other data type. Therefore a UDF is probably
your best bet. Sample UDF's are available in many places, including the teradataforum Web site.
In theory,?20 bytes can have 256^20 = 1.46E48 possible values. Even if they're all letters and digits, the number is 36^20 = 1.3E31. Some
ingenuity may be needed to make sure that the result fits into 18 digits.
| |
