NTEXT into a SELECT

[jorg32]

If I make a select that's include a column with datatype "NTEXT", length= 16 I receive the next ERROR:

"The text, ntext, and image data types are invalid in this subquery or aggregate expression."

Can I change the length or do I have to put something in front of the column name in the Select.

 

[ukwiz]

Seeing the full select statement might help to diagnose this ;-)

 

[jorg32]

The full select (this is a select in a select, but all the rest of it works) is :

select top 1 omschrijving1 from TWO TWO2 join k1 on (two2.lang=k1.taalkode)
where TWO2.tekstid='RONDER'+replace(str(max(K4RAPPELNR)),' ','') and k4.k1key=k1.k1key

The column "omschrijving1" is the one with NTEXT.

 

[SQLSister]

from Books Online:

"The ntext, text and image data types are not allowed in the select list of subqueries."

Bottom line is you can't select an ntext field in a subquery, you will have to find some other way of accomplishing your task.