ROUND Munbers in a col.

[bugzLue]

I have a Column that has $ values and i need to round it off to the second decimal from $25.36844444 to $25.37.

This is what I have tried and a few other ways that are not working. PLEASE HELP

SELECT DISTINCT CAST (mx.member AS BIGINT) Member, mxstreet, mxextra, sxcntsw, ROUND((sxbal),2) AS sxbal,

I am running SQL 2000 server. I have tried doing it on my sql 7.0 server as well. PLEASE PLEASE HELP

Thank you
Greg

I am new to this only been doing SQL for about 4 months.

 

[magdyk]

try to convert the sxbal to a numeric data type

SELECT DISTINCT CAST (mx.member AS BIGINT) Member, mxstreet, mxextra, sxcntsw, ROUND(CAST(sxbal as real),2) AS sxbal,


try it i think it will work

 

[tlbroadbent]

Convert to Decimal data type rather than Real. Real is approximate and not all value can be precisely represented. Decimal is exact. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.