Joins and Text and Image Columns

You cannot use joins for columns containing text or image values. You can, however, compare the lengths of text columns from two tables with a where clause.

For example:
where datalength(textab_1.textcol) >
datalength(textab_2.textcol)