How do I check if a SQL Server text column is empty?

sql-server sql-server-2005 sqldatatypes notnull emptydatatext

where datalength(mytextfield)=0

sql-server sql-server-2005 sqldatatypes notnull emptydatatext

ISNULL(case textcolum1    WHEN '' THEN NULL    ELSE textcolum1END ,textcolum2) textcolum1

sql-server sql-server-2005 sqldatatypes notnull emptydatatext

Actually, you just have to use the LIKE operator.

SELECT * FROM mytable WHERE mytextfield LIKE ''

CodeHunter