Smash125
Hall of Fame
Points: 3562
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply