Create custom column based off of other columns in SQL query (SQL Server)

Question

I'm having a hard time finding correct syntax to do the following:

SELECT
ColumnA,
ColumnB,
ColumnC,
(if Column1 IS Null and Column2 IS NOT NULL) Then 'Pending' Else '' AS ColumnD

I've tried IF/ELSE, IIF(), but I can't seem to get these queries to work.

Fahmi · Accepted Answer · 2020-08-30 15:51:04Z

2

use case when expression

SELECT ColumnA,ColumnB,ColumnC,
case when Column1 IS Null and Column2 IS NOT NULL Then 'Pending' Else '' end AS ColumnD 
from yourtable

answered Aug 30, 2020 at 15:51

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1