Round and Convert $ fields. RRS feed

  • Question

  • The statement and question is as follows:

    I need to convert a number such as 208135.832367 to be represented as $ 208,136. So I need to CONVERT ROUND. So far I have created the following statement that converts the field so it looks like this $ 208,135.83. The statement is:

    '$' + CONVERT(varchar(25), CONVERT(money, dbo.MSP_EpmTask_UserView.TaskBaseline0Cost, 1)) AS TaskBaselineCost,

    I am seeking for advice as to the best (or only) way to do the rounding and have a 0 decimal.

    Any assistance will be greatly appreciated.

    Thanks in advance


    Tuesday, September 23, 2008 8:35 PM