Re: Rounding in SQL

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Pete,

I converted my convoluted way of rounding to a simple expression like 
yours.  Then someone asked:  What about negative numbers?  Back 
to the convoluted. In this case .01 is for a one decimal place number 
(.001 for two places etc.) and prevents division by zero without changing 
the result.

DECIMAL(COLUMN_NAME + (.5 * (COLUMN_NAME + .01) / ABS(COLUMN_NAME + 
.01)),<length>,0)

David Morris

>>> Pete Hall <pbhall@execpc.com> 02/17 9:22 PM >>>
At 14:17 02/17/1999 -0500, Alan Novick wrote:
>Does anyone know how to round a number to the nearest whole number in
>SQL?  In other words, represent 13.9 as 14?  When I use the decimal
>function it just truncates (13.9 becomes 13).  I thought I remembered a
>function called ROUND but cannot find it in the manual.

DECIMAL(COLUMN_NAME+.5,<length>,0)
Pete Hall
pbhall@execpc.com 
http://www.execpc.com/~pbhall 

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---