My application has a table with a description field nvarchar(255) of food items. It contains many records with similar descriptions. The user in the VS .Net web application will enter one or more words in a Search For text box, separated by spaces. The stored procedure will use each of those words in a where clause with AND. See rough example attached.G--Applications-Genavix--RequiredTasks-1
I know how to do most of what I need. But I can use help on how to extract the individual words from the input parameter.
PATINDEX? Loop using CHARINDEX? Other?
Suggestions gratefully received.