How To delete NULL value rows in SQL server

Instead of writing '=' operator in where condition write 'is'.
Example shown in below,

delete tblMobiles where ImageId is NULL

Here tblMobile is table name in Database and ImageId is column name in that table