If you only want to match N” as an empty string
SELECT COLUMN FROM TABLE WHERE DATALENGTH(COLUMN) > 0
If you want to count any string consisting entirely of spaces as empty
SELECT COLUMN FROM TABLE WHERE COLUMN <> ''
If you want to use DATALENGTH for any string consisting entirely of spaces then you must use LTRIM(RTRIM(COLUMN)) before.