You cannot use text, image, or unitext columns:
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