SQLTeam.com | Weblogs | Forums

SQL Server

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.