Categories:

Numeric Functions

# DIV0¶

Performs division like the division operator (`/`), but returns 0 when the divisor is 0 (rather than reporting an error).

DIV0NULL

## Syntax¶

```DIV0( <dividend> , <divisor> )
```

## Arguments¶

`dividend`

Numeric expression that evaluates to the value that you want to divide.

`divisor`

Numeric expression that evaluates to the value that you want to divide by.

## Returns¶

The quotient. If the divisor is 0, the function returns 0.

## Examples¶

As shown in the following example, the DIV0 function performs division like the division operator (`/`):

```SELECT 1/2;
+----------+
|      1/2 |
|----------|
| 0.500000 |
+----------+
SELECT DIV0(1, 2);
+------------+
| DIV0(1, 2) |
|------------|
|   0.500000 |
+------------+
```

Unlike the division operator, DIV0 returns a 0 (rather than reporting an error) when the divisor is 0.

```select 1/0;
100051 (22012): Division by zero
```
```SELECT DIV0(1, 0);
+------------+
| DIV0(1, 0) |
|------------|
|   0.000000 |
+------------+
``` 