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
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
Last edited: