The datatypes text, ntext, and image cannot be used in an ORDER BY Clause. Similarly they cannot be compared unless you convert them to varchar or nvarchar datatypes. However you can use LIKE operator or use the condition IS NULL like below
WHERE text_col like 'test%'
WHERE text_col IS NOT NULL
SQL Server Tips · · · ·
All 3 (TEXT/NTEXT and IMAGE) are marked for deprecation, hence it would be a good idea to avoid using them in any new implementations.