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