Smash125
Hall of Fame
Points: 3563
More actions
October 6, 2012 at 8:24 am
#393327
Want to display 12.35 instead of 12.347777
imex
Ten Centuries
Points: 1234
October 6, 2012 at 8:39 am
#1546416
Try:
ROUND(12.347777, 2)
Hope this helps.
October 6, 2012 at 8:41 am
#1546417
select cast(12.34777 as decimal(5,2))
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply