Lookup using NText variable

Hi Guys,

Is there anyway to do a lookup for ntext variables?

Thanks.No, LOB columns (TEXT, NTEXT, IMAGE) are not available for lookup. If you can convert to a STR or WSTR (both in IS and in the reference table) then you could do the lookup.