Archives of the TeradataForum

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

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

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>>