<div>
Sign characters.<br />
May be placed at the beginning or end of a format string. One sign<br />
character places the edit character in a fixed position for the output<br />
string.<br />
If two or more of these characters are present on the left, the sign floats<br />
(moves to the position just to the left of the number as determined by the<br />
stated structure).<br />
The + translates to + or - as appropriate; the - translates to - or blank.
</div>


Sign characters.
May be placed at the beginning or end of a format string. One sign
character places the edit character in a fixed position for the output
string.
If two or more of these characters are present on the left, the sign floats
(moves to the position just to the left of the number as determined by the
stated structure).
The + translates to + or - as appropriate; the - translates to - or blank.

<div>
Hi Nick,<br />
can you please explain with an example how to preserve the sign ?
</div>


Hi Nick,
can you please explain with an example how to preserve the sign ?

<div>
<div class="content wysiwyg-content">
hi all,<br />
<br />
i am using &nbsp;the below query to do a fast export in teradata<br />
<br />
sel <br />
CAST((b.id &nbsp;(FORMAT 'zzzzzzzzzzzzv')) AS CHAR(12)),CAST('|' &nbsp;as char(1)),<br />
from <br />
customer b<br />
<br />
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 ?<br />
sample customer table data<br />
-7045<br />
5678<br />
<br />

</div>
</div>


hi all,

i am using  the below query to do a fast export in teradata

sel 
CAST((b.id  (FORMAT 'zzzzzzzzzzzzv')) AS CHAR(12)),CAST('|'  as char(1)),
from 
customer b

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
-7045
5678



format decimal to char

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.