How to Round Off a value in sql server

  • 11 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?
  • 11 years ago

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

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

    Joe 

Post a reply

Enter your message below

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

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!

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.

“Nine people can't make a baby in a month.” - Fred Brooks