round off after decimal greater value

Posted by Bubaibanerjee under Sql Server on 8/28/2012 | Points: 10 | Views : 2564 | Status : [Member] | Replies : 2
i am using sql server 2008R2
my data is 123.21 2458
i want it 123.22
how can i do that in sql server query.please help me
thanks in advance




Responses

Posted by: Saratvaddilli on: 8/28/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
DECLARE @value float(6)
SET @value = 123.21 2458
SELECT ROUND(@value, 2)




Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Bubaibanerjee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rambabu123 on: 8/28/2012 [Member] Starter | Points: 25

Up
0
Down
CAST(QTY_PACK AS NUMERIC(18,2))QTY_PACK,
I think this is use for u



Bubaibanerjee, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response