set @strSql='select * from #TempGoldOrder where vcCustID like '+'%''+@vcCustID+'%'
set @strSql='select * from #TempGoldOrder where vcCustID like '+'%''+@vcCustID+'%'
--this set @strSql='select * from #TempGoldOrder where vcCustID like %'''+@vcCustID+'%'
set @strSql='select * from #TempGoldOrder where vcCustID like ''%'+@vcCustID+'%'''
set @strSql='select * from #TempGoldOrder where vcCustID like ''%'+@vcCustID+'%'''
[code=SQLdeclare @strSql nvarchar(4000),@vcCustID varchar(50) set @vcCustID ='001' set @strSql='select * from #TempGoldOrder where vcCustID like ''%'+@vcCustID+'%'' ' --print @strSql --exec sp_Executesql @strSql exec(@strSql) [/code]
set @strSql='select * from #TempGoldOrder where vcCustID like %'''+@vcCustID+'%'
set @vcCustID ='001'
set @strSql='select * from #TempGoldOrder where vcCustID like ''%'+@vcCustID+'%'' '
--print @strSql
--exec sp_Executesql @strSql
exec(@strSql)
[/code]