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

Question :

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

Answer :

I am using SQL Server 2005. I have a table with a text column and I have many rows in the table where the value of this column is not null, but it is empty. Trying to compare against ” yields this response:

The data types text and varchar are incompatible in the not equal to operator.

Is there a special function to determine whether the value of a text column is not null but empty?

Read More  How to send MMS with C#

,

where datalength(mytextfield)=0  

That’s the answer How do I check if a SQL Server text column is empty?, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.

Disclaimer :

The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you