SELECT CONVERT(varchar(32), CAST(9898989 AS money),1)

It's better to do any formatting on the frontend becase T-SQL has limited cpacities in that area.

>hi in vfp i use tranform() for put comma on currency value .
>

>transform(9898989,"@999,999.99")
>

>how can i do this in SQL server?
>thanks