exec('select * from item where itemid like '''+@newid+''' order by itemid')
create table item(itemid varchar(20)) insert into item(itemid) select 'abcd' insert into item(itemid) select 'bcd'declare @newid varchar(20) set @newid='a' select * from item where itemid like '%'+@newid+'%' order by itemid
create table item(itemid varchar(20))
insert into item(itemid) select 'abcd'
insert into item(itemid) select 'bcd'declare @newid varchar(20)
set @newid='a'
select * from item where itemid like '%'+@newid+'%' order by itemid