What is your SQL Server version? In SQL Server 2016 and up try this solution:
create or alter procedure GetSalesInfo
(@startDate date = '05/22/2022', @EndDate date = '05/26/2022',
@Products varchar(max) = 'RICE, Noodles, SWEET POTATOES, STEAK, ROASTED PEANUTS')
AS
begin
declare @Words table (word varchar(40))
insert into @Words (word)
select rtrim(ltrim(value)) from string_split(@Products, ',') where value <> '';
SELECT s.* FROM SALES s
inner join @Words w on s.Word like '%' + w.word+'%'
WHERE s.SALESDATE BETWEEN @startDate and @EndDate ;