I have a table with a "Description" field. Which contains the titles of a whole lot of phone models.
**Table1** Id - Int (PK) Description - nvarchar(200) **Lookup Table** LookupId - Int (PK) SearchString - nvarchar(50) Result - nvarchar(100)
I then have another lookup table with all the different models of phones I want to search for.
If I was going to do a text search on the description field I could easily write this by doing
SELECT * FROM Listing WHERE Description Like '%SearchTerm%'
However I want to somehow do a search on each record in the Lookup Table. Im thinking that I probably have to do a loop for each record in the Lookup table and then write some dynamic sql? Is there an easier way than this?