How to check for Is not Null And Is not Empty string in SQL server?

Question

How can we check in a SQL Server `WHERE` condition whether the column is not null and not the empty string (`''`)?

Answer 1

WHERE someColumn IS NOT NULL AND someColumn != ''