SQL Server: How To Query Based On An Empty String Column

There are at least 2 ways which I know of.

Select column1, column2 from tableName where column1 <> ''

Remember, use single quotes, not double quotes!

Select column1, column2 from tableName where datalength(column1) > 0