You cannot use text, image, or unitext columns:
In order by, compute, group by, and union clauses
In an index
In subqueries or joins
In 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.
