Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 21 Dec 2007 @ 21:16:23 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Row CheckSum
From:   Michael Larkins

Hello Bill:

The problem is that you seem to assume that the sel char2hexint('a') outputs an integer. It does not. The output is CHAR. If you want it to be numeric you will need to convert it using something like this: sel char2hexint('a') (int)

To verify this fact: sel type(char2hexint('a'))

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016