Changing a neg # to a positive when selecting?

[cyprus106]

I'm trying to show some data, and for a complicated reason, all of the integers in a particular field are negative. They're converted to positive in the program that uses them, but I'm using a SELECT statement to show the numbers, and I need them to be shown as positives (and realistically I'd love to show a "$" in front of them, but one battle at a time").

I don't have a CLUE how to do this; is there a way to do this in the select? Hopefully somebody here can help.

Cyprus

 

[unclejimbob]

select the_number*-1 from the_table