text, image, and unitext columns cannot be used:
As parameters to stored procedures, except when set textptr_parameters is on
As local variables
In order by, compute, or group by clauses
In indexes
In subqueries
In where clauses, except with the keyword like
In joins