How to build a like query dynamically for execute SQL activity

[shanugoel]

I have tried this
“Select WELLIDA, WELLNAME
FROM dbo.wvwellheader Where wellname LIKE '%” & @WellName & “%’”

and this

“Select WELLIDA, WELLNAME
FROM dbo.wvwellheader Where wellname LIKE '%” + @WellName + “%’”

but i get error “String constants must end with a double quote”

[AshwinS2 (Ashwin S)]

hi @shanugoel
Use this

Select WELLIDA, WELLNAME
FROM dbo.wvwellheader Where wellname LIKE ‘%’ and @WellName like ‘%’"

Thanks
Ashwin S

[shanugoel]

@AshwinS2

Select WELLIDA, WELLNAME

FROM dbo.wvwellheader Where wellname LIKE ‘%’ and @WellName like ‘%’"

Thanks. This works great.