SQL minus 2 columns - with null values

Question

I have this table (made from a SQL query): ``` Row 1 Row 2 2 1 3 NULL ``` And I want to minus the 2 columns, so I just select like this: ``` Select Row1 - Row2 From table ``` But then I get this result: ``` 1 NULL ``` instead of: ``` 1 3 ``` How can I make it possible to get the last result?

Accepted Answer

Please try:

```
SELECT ISNULL([Row 1], 0) - ISNULL([Row 2], 0) from YourTable
```

For more Information visit ISNULL

SQL minus 2 columns - with null values

Solution

Problem