How can we check in a SQL Server WHERE condition whether the column is not null and not the empty string ('')?
WHERE column !='' AND column IS NOT NULL
1 Like
WHERE column > ''
No need to check for IS NULL - because NULL > '' will evaluate to unknown and be excluded.