Tracy,

You don't need column list in any EXISTS subquery
Try

SELECT * from itable c 
	WHERE EXISTS (SELECT 1 FROM ttable a WHERE a.inci_id = c.inci_id 
				and exists ( SELECT 1 FROM vtable b 
					WHERE b.vehi_id = a.vehi_id AND licpl_no LIKE '%UNKNOWN%' 
						AND len(make)= 0 AND LEN(model)=0))

>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
>>