Community discussion forum

How to Round Off a value in sql server

• • Reply

  7 months ago

  by amarkov

  amarkov

  , United States

  Joined 9 months 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
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  6 months ago

  by joe90

  J Alan

  , United Kingdom

  Joined 3 years ago

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

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

  Joe 

  Report abuse