You cannot use text, image, or unitext columns in some places.
order by, compute, group by, and union clauses
An index
Subqueries or joins
A where clause, except with the keyword like
In triggers, both the inserted and deleted text values reference the new value; you cannot reference the old value.