Hi
I am querying data from sqlserver there i want to display output with 2 decimal points .Doing like this
ex: select round(sales,2) from x

sales="12345.67789"

here i am getting 123456.68000 but i need to dispaly 123456.68 only.Sales data is not fixed length so i cant use left or right function.How to get with 2 decimal points?

Please check the following articles:

http://www.databasejournal.com/featu...0894_2222111_3
http://www.sqljunkies.com/Forums/Sho...px?PostID=1028

Om Prakash

Dear om_prakash
 these article simply round the floating number into nearest decimal number and the question of msrnivas is truncate the number into two decimal places







Cheers






Love 4 all

Hi Thanks 2 all got the result

select cast(round(567.677,2,0) as decimal(20,2))

Cross post

http://p2p.wrox.com/topic.asp?TOPIC_ID=15734

Love 4 all