Home Forums SQL Server 2008 T-SQL (SS2K8) How to convert to two decimal places RE: How to convert to two decimal places

  • 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)

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths