Home Forums SQL Server 7,2000 T-SQL Formatting Numeric Output for Decimal Places RE: Formatting Numeric Output for Decimal Places

  • July 30, 2004 at 12:47 pm

    #517091

    If you're presenting the results of this query on the web, you might need to use a align="right" tag and this will format the number to TWO decimal places:

    <%=FormatNumber(rs("BD_TR_AMT"),2,-1)%>

    Hope this helps.


    Butch