Delete ROW where Value in column is NULL

Question

How do I delete out any rows from a table named:

bhxsql2014-dev.dbo.EUACTIVESTORES

Where the column [Store No] has a NULL value

I'm using MS SQL Server Management Studio

Answer 1

Here is what you need:

delete from [bhxsql2014-dev].dbo.EUACTIVESTORES
where [Store No] is null