V
V
Vladimir2019-04-04 15:38:24
SQL
Vladimir, 2019-04-04 15:38:24

How to select all records where date is NULL AND date is 20190101?

How to select all records where date is NULL AND date is 20190101
(needed in one query!)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-04-04
@vovaburyii

It is possible WHERE ([date] IS NULL) OR ([date] = '20190101').
And you can WHERE (ISNULL([date], '20190101') = '20190101').

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question