declare @productCode as varchar(150) declare @mfrName as varchar(150) select @productCode = #attributes.datasource#.dbo.RemoveChars('#_sku#','32,45') select @mfrName = #attributes.datasource#.dbo.RemoveChars('#_MfrName#','32,45,39') select s.skuid, m.mfr_id, m.mfr_name, s.sku, s.skudesc, s.packsizeDesc from tbl_PRD_Skus s with (nolock) inner join tblManufacturers m with (nolock) on s.mfrid = m.mfr_id and mfr_name NOT LIKE '%delete%' where s.fsl_TableCode = 'MFR' and #attributes.datasource#.dbo.RemoveChars(s.sku,'32,45') = @productCode and #attributes.datasource#.dbo.RemoveChars(m.mfr_name,'32,45,39') like '%' + @mfrName + '%' declare @productCode as varchar(150) declare @mfrName as varchar(150) select @productCode = fslibrary_rpc.dbo.RemoveChars('7978310022 ','32,45') select @mfrName = fslibrary_rpc.dbo.RemoveChars('Kelloggs','32,45') select s.skuid, m.mfr_id, m.mfr_name, s.sku, s.skudesc, s.packsizeDesc from tbl_PRD_Skus s with (nolock) inner join (select mfr_Name, mfr_id from tblManufacturers m where mfr_Name NOT LIKE '%Delete%') as m on m.mfr_id = s.mfrid where s.fsl_TableCode = 'MFR' and fslibrary_rpc.dbo.RemoveChars(s.sku,'32,45') = @productCode and fslibrary_rpc.dbo.RemoveChars(m.mfr_name,'32,45,39') like '%' + @mfrName + '%'