Serge - I'm looking for SPT syntax, not VFP... I cannot find "Transform" or PADR in the SQL books!

>Michel,
>
>Try

 PADR(TRANSFORM(FromValue, "@$ 999,999") + " - " + ;
>         TRANSFORM(ToValue, "@$ 999,999"),32) AS DisplayValue,

>>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