Deleting rows containing NULL values.

[Tryst]

Hi all,

How do I delete a row where the criteria on the row to be deleted is NULL.

An example, I have a table called images, and one of the columns is called location. So if I wanted to delete all the rows in the images table where the value in the location column = NULL, how do I create the query?

So far I have tried the following in my queries...

WHERE location = NULL;
WHERE location = 'NULL';
WHERE location = "NULL";

But to no avail.

Thanks

Tryst

[kcomer]

Try "WHERE location IS NULL"

[Tryst]

Thats worked a treat.

Thank you, kcomer.

Tryst