How to I using the Sql to select the remark column?

[dormingo]

hello guy, I'm write the Sql stamement and try to run on sql query analyzer and get the error message

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

I try to select the remark column and its data type is - Text

my sql stament include the sum and group by..

thank you.

 

[bborissov]

It is always a good idea to post sample of your SELECT
And tell us type of the columns included.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.