I am querying out a number and it gives me the number like 54.5000<BR><BR>I would like to trim it down to a 54.50 format. How can this be achieved?
.. and where you want to do to the trimming.<BR><BR>In ASP, it's simple:<BR><%=FormatNumber(Recordset("Field") , 2) %>
I am using MSSQL and need to do it at the query level.
I tried round(field, 2) to no avail.
CONVERT(decimal(10,2), CONVERT(varbinary(20), <field>))<BR>
did the trick!