Query not picking up NULLS

[kbreiss]

The following query is not returning records that are NULL in the Sanction field. If I take out the (NOT LIKE 'DELETE*') it returns all records even the the ones that are NULL in the Sanction field.

Why is this query not returning records that are NULL in the sanction field? I want to include all records that are not like delete only...I don't care if they are null....

SELECT DL
FROM DIGITAL
WHERE SANCTION Not Like "DELETE*";


Thanks in advance,
Kacy
________
Paxil help

 

[Rich]

You need to add Or Is Null to the clause

 

[kbreiss]

Yes..I know this will work, but I am more curious than anything on when using this criteria it doesn't pick up the nulls?
________
Mary Jane

 

[The_Doc_Man]

WHERE SANCTION Not Like "DELETE*";

returns the records with null SANCTION because a null is not like DELETE* - which is exactly what you asked for. THAT'S why it returns records holding nulls...

 

[kbreiss]

returns the records with null SANCTION because a null is not like DELETE
________
Free Streaming Amateur Por

 

[kbreiss]

returns the records with null SANCTION because a null is not like DELETE....

thats the problem...it does NOT return records with a null SANCTION. Why is this?
________
Asian Webcam

 

[pbaldy]

Null is not "Like" anything, nor is it unlike anything. I'd describe it as unknown, and it doesn't react well to tests with =, <>, etc. You have to do what Rich recommended.