Hello, need your expect help to refine my View in order to join two tables with partial match of the whole word list. In the attached screenshot, ProductID 12 and 36 should not be listed because the whole word in ProductName is not = to "Mix" but SillMix and MixPastora.
SELECT dbo.Products.ProductID, dbo.Products.ProductName, dbo.NAMES.FullNameFROM dbo.Products INNER JOIN dbo.NAMES ON dbo.Products.ProductName LIKE '%' + dbo.NAMES.FullName + '%'
Thank you Shalu, the problem is that dbo.NAMES.FullName has a very lengthy (8k) list of key words that I need to match in the dbo.Products.ProductName to run an update on.