I try to use `select` to create a new column based on the sum of existing columns. When one of the records is empty, the return would be empty instead of the number of other columns.

For example, table\_A having 2 columns as below:

```
Column_A Column_B
1        10
2
3        30

```

When I run a query:

```
Select (Column_A + Column_B) as New_Column from table_A

```

Result:

```
New_Column
11

33

```

My desired result:

```
New_Column
11
2
33

```

I searched for a while and found that Column\_A + ISNULL(Column\_B,0), would give me what I want.

However, it is a very simple case, I actually handle a lot of columns in which I don't know which column having empty data. Any better way instead of putting `ISNULL` before each calculation?