text, unitext, and image columns cannot be used:
As parameters to stored procedures
As values passed to stored procedures
As local variables
In order by, compute, and group by clauses
In an index
In a where clause clause, except with the keyword like
In joins
In triggers, both the inserted and deleted text values reference the new value; you cannot reference the old value.
