MSSQL - How to fix error - The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Watch this example on YouTube

  

Replace

SELECT TOP (1000) id,comment

FROM Test.dbo.TableTest

GROUP BY id, comment  

With

SELECT TOP (1000) id,CAST( comment AS VARCHAR)

FROM Test.dbo.TableTest

GROUP BY id, CAST( comment AS VARCHAR)