i am using the below query to do a fast export in teradata
CAST((b.id (FORMAT 'zzzzzzzzzzzzv')) AS CHAR(12)),CAST('|' as char(1)),
here the column id in table has both negative and postive values but the above sql changes all negative numbers to postive. can anyone suggest me how to retain the negative number when i do select ?
sample customer table data
The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.