Another Stumper

J

JimS

You'll probably get this one right away...

I have a table with 66000 rows. 57000 rows have a Proj# column that is of
the form "C00000". Three rows have spurious stuff in the Proj# column like
"Total" and "Report Run...." 9,000 or so rows have a null in that column.

I ran a query that couldn't be simpler:

DELETE AllMatreqIssues.[PROJ #]
FROM AllMatreqIssues
WHERE (((AllMatreqIssues.[PROJ #]) Not Like "C*"));

It only deletes the three rows with spurious characters. It does not delet
the rows that are null. Why?
 
M

Marshall Barton

JimS said:
You'll probably get this one right away...

I have a table with 66000 rows. 57000 rows have a Proj# column that is of
the form "C00000". Three rows have spurious stuff in the Proj# column like
"Total" and "Report Run...." 9,000 or so rows have a null in that column.

I ran a query that couldn't be simpler:

DELETE AllMatreqIssues.[PROJ #]
FROM AllMatreqIssues
WHERE (((AllMatreqIssues.[PROJ #]) Not Like "C*"));

It only deletes the three rows with spurious characters. It does not delet
the rows that are null. Why?
Click to expand...


WHERE [PROJ #] Not Like "C*" OR [PROJ #] Is Null

Null is neither like nor unlike anything.
 
Top