>I'm having trouble finding the syntax to return a dollar-formatted string (commas, dollar sign) from an integer value. > >What I have now is: >SELECT STR(FromValue) + ' - ' + STR(ToValue) AS DisplayValue, STR(AssetsCode,2,0) AS cValue... > >which returns a 'displayvalue' of "1000 - 25000" > >But I want it to return "$1,000 - $25,000" > >TIA