Decimal numbers

[happyIndian100]

a simple question,

select cast(156/100 as numeric(13,3))

output i get is 1.000

but in actual it should be 1.560

please help...

 

[gmmastros]

Integer math before the conversion to decimal. Try this instead.

select cast(156 as numeric(13,2)) / Cast(100 as numeric(13,3))


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

or this

select cast(156/(100 *1.0) as numeric(13,3))

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/