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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.