External Data-Changing Numeric Formatting
Just negate the value in your SQL:
select -t.columname from tablename t
Tim
"Cheryl" wrote in message
...
Hi All,
I am importing external data via database query. There is one column of
data that is in the positive position that needs to be converted into the
negative position (entire column). i.e. 21.63 needs to read as -21.63.
Can
this be done?
Thanks in advance.
Cheryl
|