1 out of 2 rated this helpful - Rate this topic

# ROUND Function

SQL Server 2012

Rounds a number to the specified number of digits.

```
ROUND(<number>, <num_digits>)
```

Term

Definition

number

The number you want to round.

num_digits

The number of digits to which you want to round. A negative value rounds digits to the left of the decimal point; a value of zero rounds to the nearest integer.

A decimal number.

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.

If num_digits is 0, the number is rounded to the nearest integer.

If num_digits is less than 0, the number is rounded to the left of the decimal point.

### Related Functions

To always round up (away from zero), use the ROUNDUP function.

To always round down (toward zero), use the ROUNDDOWN function.

To round a number to a specific multiple (for example, to round to the nearest multiple of 0.5), use the MROUND function.

You can use the functions TRUNC and INT to obtain the integer portion of the number.

The following formula rounds 2.15 up, to one decimal place. The expected result is 2.2.

```=ROUND(2.15,1)
```

The following formula rounds 21.5 to one decimal place to the left of the decimal point. The expected result is 20.

```=ROUND(21.5,-1)
```