Currency question sql?

Format the column to display the numbers as currency instead. Sometimes if you force the $ into the output it will be treated as a string instead of a number which will really mess up your sort order.