text, ntext and image data types cannot be compared

I

Ian

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Field Problem with a NText (Memo) type of field 2
Trying to Cast Ntext as nvarchar in order to use Group BY 5
Concatenate Text Fields to Date Field 5
Update type conversion error with nulls 3
Count function and SQL2k5 0
Can't update NTEXT field on SQL2K...HELP! 2
Search for current date in a text field 9
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0

Top