Back to discussion

How to Round Off a value in sql server

Last post was 26 May 2008 at 16:53
sql server Cleveland, United States
  • 12 years ago
    Hi all i want to round off a float value and displaying in results pane Like My value is (0.930232558139535) i want display it as 0.930 how is this possible?
    Report abuse
  • 12 years ago

    Would the sql server "Round" function not do what you want?

    as in "round(843.3423423423, 2)" = 843.3400000000  

    Joe 

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

SQL Server forum discussion

SQL Server tutorials

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“In order to understand recursion, one must first understand recursion.”