Archives of the TeradataForum

Message Posted: Tue, 06 Mar 2007 @ 20:30:59 GMT

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

Export the data to a text file; then run it through a program to convert the hex digits to characters. The Perl pack function, for instance, can do this.

If you want to display the bytes in char form via SQL, you will need a UDF.

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