Find where word from one column exists in string of a different column

[bmacbmac]

Hi,

I have the following table

create #temp (folder varchar(20), itexists varchar(1))

I would like to set the itexists folder = 'x'
where folder is in a string from another column of another database... something like this..

update #temp
set itexists = 'x'
where folder in (select imagepath from mytable2)

However the imagepath will be a long string. I just want to know if the single word in [folder] exists in [imagepath]

 

[gmmastros]

try this:

update #temp
set itexists = 'x'
where exists(Select 1 from mytable2 where imagepath like '%' + folder + '%')

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bmacbmac]

Perfect thanks!