I have a table with descriptions of a lot of companies.
[CompanyID] [int] IDENTITY(1,1) NOT NULL,
[CompanyProfile] [nvarchar](max) NOT NULL
"Agilent Technologies, Inc. provides application focused solutions to
[Pattern] [nvarchar](100) NOT NULL
You could filter out rows for which any pattern does not match:
select * from TblCompanies c where not exists ( select * from TblFilter f where c. CompanyProfile not like '%' + f.Pattern + '%' )