Rounding

[krotha]

When I query a field from the Query Analyzer I get
0.57999999999999996. But from EM it shows 0.58. How shall I get 0.58 from the query analyzer.

 

[NoCoolHandle]

select cast(0.57999999999999996 as numeric (10,2))

 

[donutman]

cast(YourField as numeric(12,2)) or the like.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[SQLSister]

Sounds like your field is a float or real datatype. Do not use these datatypes if you want an exact number as they are always approximations. Use numeric or decimal instead.

Questions about posting. See faq183-874