Number Format problem.

[dwight1]

I have a table that has a field (orgamt) data type as decimal. I have a view based on this table and i can go to the properties of that field and change the data type to standard with decimals zero.

My problem is, in the next step i have a sp with a case statement and i give an alias to the field name. For example,

Sum(CASE WHEN Crosstab = 1 THEN Orgamt ELSE 0 END) AS 'Balance'

Now, here the format of the number comes as 123456.00 but i want it to be 123,456 and with out decimals.

Can any one advise me please on this?

Thank you

Dwight

 

[cmmrfrds]

Look up the Cast or Convert Functions.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

Probably something like.
CONVERT(decimal(10,0), Sum(CASE WHEN Crosstab = 1 THEN Orgamt ELSE 0 END) ) AS 'Balance'

 

[dwight1]

Thank you..it worked.