Click to See Complete Forum and Search --> : Move the negative sign to the right (to_char)?


mrpaulwass
09-26-2002, 03:44 PM
Is there a way using to_char to move the negative sign to the right?

SELECT trim(to_char(-35000000,'$999,999,990')) FROM dual

results in
-$35,000,000

I would like it on the right.

Thanks,

P

jmodic
09-26-2002, 07:27 PM
SELECT trim(to_char(-35000000,'$999,999,990MI')) FROM dual

mrpaulwass
09-27-2002, 10:31 AM
Thank you very much :o)