text, ntext and image data types cannot be compared

[Guest]

Posted this in the sql datamining group but no response. Hoping someone can
help. I'm trying to sort out a sql statement used to datamine thru excel.
The problem is it won't retrieve a text field.

Beginner user to data mining and creating SQL statements. I'm designing my
SQL statements through excel to create dashboards for staff. I want to
display a text field (it's a comment section in the app.) but I get the error
"the text, ntext and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator"

I tried adding a HAVING statement for IS NULL OR IS LIKE '%' but I get the
same error. Can someone help me out? I presume to get it to do a wild card
search of that field?

 

[Jamie Collins]

I get the error
"the text, ntext and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator"

Try casting the values to another type (e.g. VARCHAR).

Jamie.

--