How can I delete rows with "Empty Strings" in a column in SQL Server?

Question

I have many rows/records where one of the columns (movieId) is void of any useful values:

Based on the answer here, the following should work:

...but it doesn't, as you can see in the rectangled "no rows affected"

How can I eliminate/delete all the rows with nothing (but empty space) in the MovieId column?

Answer 1

One explanation as to why your IS NULL delete is not working is that the MovieId values are empty string, rather than NULL. Here is an option you can use to handle both NULL and empty string at the same time:

DELETE
FROM dbo.ACTORS_MOVIES_M2M
WHERE COALESCE(MovieId, '') = '';