NULL variable not getting results

Question

I have the following query :

DECLARE @dt AS DATE = NULL;

SELECT orderid, shippeddate
FROM Sales.Orders
WHERE shippeddate = @dt;

I have some Orders with NULL shippeddate but they are not returned when executing the above query.

Does this answer your question? Not equal <> != operator on NULL — Bill Tür stands with Ukraine
– Bill Tür stands with Ukraine, Commented Apr 5, 2020 at 14:16

Gordon Linoff · Accepted Answer · 2020-04-05 14:16:27Z

3

You need to check for NULL using IS NULL. So:

WHERE shippeddate = @dt OR (shippeddate IS NULL AND @dt IS NULL)

answered Apr 5, 2020 at 14:16

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

Comments

Vahid Heydarinezhad · Accepted Answer · 2020-04-07 06:53:51Z

1

DECLARE @dt AS DATE = NULL;

SELECT orderid, shippeddate
FROM Sales.Orders
WHERE shippeddate = @dt  or (shippeddate IS NULL AND @dt IS NULL)

answered Apr 7, 2020 at 6:45

1264 bronze badges