Remove * from your EXISTS statements. The purpose of EXISTS is to check if the query satisfies certain criteria, not to actually select fields.
>the field canccomm in ttable is text and the fields vhfeature and vhnotes in vtable are text...
>
>
>
>>Which field(s) is/are text?
>>BTW LEN() doesn't count trailing spaces, so
>>
>>LEN(LTRIM(RTRIM(model))) = 0
>>is the same as
>>LEN(model) = 0
>>
>>>The below query returns this error: The text, ntext, and image data types are invalid in this subquery or aggregate expression
If it's not broken, fix it until it is.
My Blog