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)
Copyright © 2005. Sybase Inc. All rights reserved. |