praveen_vejandla (1/22/2013)

---

UPDATE LII

SET value_exists = 1

FROM LII od

JOIN VPL sl

ON (sl.it like '%' + od.value + '%'

AND od.opr = 9 )

WHERE od.tn = 'VPL'

AND od.cn = 'it'

Is there anyway to rewrite above query for improved performance? I am joining two nvarchar columns (it, value) using LIKE and it seems very slow.

Thanks.