Using a variable within a wildcard

[bmacbmac]

Hi,

This is a simple example of what I am trying to do. Is there a way to use the variable in a wildcard of my select statement?

declare @folder varchar(200)
set @folder = (select min(folder) from #folders)

select * from #tempimages where path like '%@folder%'

 

[yelworcm]

declare @folder varchar(200)
set @folder = (select min(folder) from #folders)

select * from #tempimages where path like '%' + @folder% + '%'

 

[yelworcm]

Hmm. i don't see an edit post button.

declare @folder varchar(200)
set @folder = (select min(folder) from #folders)

select * from #tempimages where path like '%' + @folder + '%'

 

[bmacbmac]

Well that was simple. Worked great!