|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/22/2008 5:23:06 PM
Posts: 2,
Visits: 4
|
|
I am trying to format a decimal field to get the commas displayed using: CAST((( SAUP) (FORMAT 'ZZ,ZZZ,ZZ9.99')) AS CHAR(13))) (NAMED VALUE1), which works but now I want to right justify the data as if it were an integer field. I cannot find any functions or command to right justify this character data. Please help. Thank you.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/25/2008 1:20:39 PM
Posts: 91,
Visits: 119
|
|
The CHAR cast is not needed. Just use the format:
SAUP (FORMAT 'ZZ,ZZZ,ZZ9.99' (NAMED VALUE1),
If you are exporting using FastExport this will not work unless you specifiy format TEXT in the export command.
|
|
|
|