InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:32:25 GMT20http://www.teradata.com/teradataforum/Topic11589-11-1.aspxRelease:V2R6.1We have data in a Teradata table with a data type of VARCHAR(322) CHARACTER SET LATIN NOT CASESPECIFICFor example, the following:0B886091F4B04FF6038D6C7E6F001BBC00FF98C964000000.XXXXThis 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.Fri, 23 May 2008 15:14:11 GMTbutseriouslyfolks