SQL Server query not returning expected row

Question

Using SQL Server 2016, I have one row in a table, and I am trying to craft a query to select the primary key from that row, based on two columns.

I know the information in the row, but when I include the info in the where clause it still doesn't find anything. Below is the screenshot showing the row and the query. The query returns nothing.

I also tried using the & operator, and I tried putting the 22 in '' and (). The finished column is datatype binary(50), and the DoorNum column is datatype int.

select * 
from Dropoff 
where finished = NULL 
  and DoorNum = 22;

score 4 · Accepted Answer · answered May 10 '17 at 18:01

Do not use "=" for NULL values. Because nothing equals NULL, not even NULL. NULL means "Unknown"... if you can't know what's in it, you can't compare them.

Change your query to this:

select * from Dropoff 
where finished IS NULL and 
      DoorNum = 22;

score 3 · Answer 2 · answered May 10 '17 at 18:01

3

I think it "is null" to check null values as below:

select * from Dropoff 
where finished is NULL and 
  DoorNum = 22;

answered May 10 '17 at 18:01

Kannan Kandasamy

13,405
3
25
38

score 2 · Answer 3 · edited May 23 '17 at 10:31

2

Use IS NULL instead as next:-

select * from Dropoff 
where finished is NULL and 
DoorNum = 22;

Follow These:-

SQL is null and = null

what is “=null” and “ IS NULL”

Is there any difference between IS NULL and =NULL

edited May 23 '17 at 10:31

Community

1
1

answered May 10 '17 at 18:01

ahmed abdelqader

3,409
17
36

Ilyes · Answer 4 · 2017-05-10T18:10:01.060

1

You shoud use Is Null instead:

SELECT * 
FROM Dropoff 
WHERE finished is NULL and DoorNum = 22;

Use Is Null to determines whether a specified expression/Value is NULL.

edited May 10 '17 at 18:10

answered May 10 '17 at 18:03

Ilyes

14,640
4
29
55

SQL Server query not returning expected row

4 Answers4