Home Forums SQL Server 2008 T-SQL (SS2K8) How to convert to two decimal places RE: How to convert to two decimal places
Vedran Kesegic
SSCrazy Eights
Points: 9302
More actions
November 5, 2012 at 6:09 pm
#1556261
Use STR function. E.g:
declare @x money=12345.69851
SELECT [STR]=STR(@x, 20, 2), [CONVERT_default]=CONVERT(varchar(20), @x), [CONVERT_format_1]=CONVERT(varchar(20), @x, 1), [CONVERT_format_2]=CONVERT(varchar(20), @x, 2)