Archives of the TeradataForum

Message Posted: Thu, 31 Mar 2005 @ 08:22:14 GMT

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

Assuming you store the hex data as (VAR)CHAR (BYTE types do not convert easily to something else), you could try

     select your_hex_string_column_name XB
     from table_name ;

with subsequent CASTs to INT etc, if necessary.

Regards,

Victor

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