rekha_sara
SSC-Addicted
Points: 467
More actions
October 19, 2009 at 10:55 pm
#139692
Is there a way where nvarchar field for example is populated as 223.56 Then I want to change it to be 223.56000 to have 5decimal places?
sanoj_av2001
SSChasing Mays
Points: 601
October 19, 2009 at 11:24 pm
#1067961
Select convert(decimal(12,5),223.56)
..
October 20, 2009 at 12:39 am
#1067980
Thanks for the quick response
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply