|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/26/2008 11:33:20 AM
Posts: 1,
Visits: 10
|
|
Release:V2R6.1
We have data in a Teradata table with a data type of VARCHAR(322) CHARACTER SET LATIN NOT CASESPECIFIC
For example, the following:
0B886091F4B04FF6038D6C7E6F001BBC00FF98C964000000.XXXX
This represents hexadecimal values.
The dot, '.', in the above example represents/would be expanded to 64 zeros.
The 'X' is expanded to 16 zeros.
Need to translate this example into a binary representation and land it in another Teradata table.
Is there a UDF which would handle the transformation?
What has been accomplished so far is to use XI2 to get into a decimal format.
ie. to transform "F" , use select 'F'XI2;
Looking forward to your reply. Thank you.
My Best Regards, A Thankful Listener.
|
|
|
|