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)