I have Data with 3 decimals . need to round off with 4 as defalut.
select value from table
I need as below
see the e.g
select cast(1.123 as decimal(9,4))
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?