TERADATA TIP，
1.change from char to hex
select char2hexint('A')
2.change from hex to char
select (x'0041')
3.trim the x'0000' in a string( x'0000' is hex representation of the end of the line )
TRIM(TRAILING _UNICODE '0000'xc FROM CMPGN_ID)
4.http://developer.teradata.com/blog/dnoeth/2012/10/how-to-simplify-your-statistics-collection-with-a-queue-table
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。