shanugoel
(shanu goel)
#1
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)
#2
hi @shanugoel
Use this
Select WELLIDA, WELLNAME
FROM dbo.wvwellheader Where wellname LIKE ‘%’ and @WellName like ‘%’"
Thanks
Ashwin S
shanugoel
(shanu goel)
#3
Thanks. This works great.