text and image columns cannot be used:
As parameters to stored procedures or as values passed to these parameters
As local variables
In order by clause, compute clause, group by, and union clauses
In an index
In subqueries or joins
In a where clause, except with the keyword like
With the + concatenation operator
In the if update clause of a trigger