declare @PI_ProdName varchar(100)
set @PI_ProdName = 'ss'
select * from HZ_Product_Info where PI_ProdName like '%'+@PI_ProdName+'%'
declare @PI_ProdName varchar(100)
set @PI_ProdName = 'ss'
select * from HZ_Product_Info where PI_ProdName like '%'+@PI_ProdName+'%'