ASP.NET (35) SQL (25) JAVASCRIPT (24) HTML (14) STYLE SHEET (6) ASP (4) SCRIPT (1)

Search me out HERE!!

ROUND UP "FLOAT" Value in SQL Query.

Below query shows how to round up FLOAT datatype field in SQL Query itself.

SELECT ROUND(FieldName,2) AS TEST FROM TableName

Here there will be '2' digits after decimal point. You can change this number as per your requirement.

No comments:

Post a Comment