Searching word

[kumark]

Seraching keyword in a string ..Please find the enclosed attachment

 

[kumark]

I got the Solution ....


select * from t1, t2
where t1.STRING like '%' + t2.KEYS + '%'


update t1 set validate='found' from t1 inner join t2 on t1.STRING like '%' + t2.KEYS + '%'

 

[John Big Booty]

Please desist from double (triple) posting. You have already had one other thread on this subject deleted. Further instances of multiple posting are liable to be treated as SPAM, with all the attendant penalties.