<div>
what's the problem? an error?
</div>


<div>
ok, the Min was a mistake...but this is found as a subquery, so it is still coming up with the same error
</div>


ok, the Min was a mistake...but this is found as a subquery, so it is still coming up with the same error

<div>
sorry....the error is stated in the title: &nbsp;The text, ntext, and image data types are invalid in this subquery or aggregate expression.
</div>


sorry....the error is stated in the title:  The text, ntext, and image data types are invalid in this subquery or aggregate expression.

<div>
a very simplified version of the actual query... <br />
select (SELECT (Memo) FROM PmtsMemos WHERE PmtsMemos.InfinityRecNo = 620073)
</div>


a very simplified version of the actual query...
select (SELECT (Memo) FROM PmtsMemos WHERE PmtsMemos.InfinityRecNo = 620073)

<div>
the agg function was a mistake... i fixed it by cast(memo as nvarchar)<br />
<br />
thanks
</div>


the agg function was a mistake... i fixed it by cast(memo as nvarchar)

thanks

<div>
<div class="content wysiwyg-content">
SELECT MIN(Memo) FROM PmtsMemos WHERE PmtsMemos.InfinityRecNo = 0 <br />
<br />
in this example the memo field is ntext. <br />
<br />
What can i do?<br />
<br />

</div>
</div>


SELECT MIN(Memo) FROM PmtsMemos WHERE PmtsMemos.InfinityRecNo = 0 

in this example the memo field is ntext. 

What can i do?



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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.