I need some help writing a select statement (I still don't think in sets!). Here's the scenario:
I have table A with column "Name varchar(20)". I have table B with column "SearchTerm varchar(20)". I want to query A for any rows that are like any search term in B.
Let me give specific data:
Table A has:
Jay
Jim
Frank
George
If table B has 'a', then the results would be:
Jay
Frank
If table B has 'j', then the results would be:
Jay
Jim
If table B has 'y' and 'g' (two rows), then the results would be:
Jay
George
If table B has 'Jay', then the results would be:
Jay
I actually want to be able to apply this idea to be able to search two columns, FirstName and LastName, but I'm guessing that once I see the idea, I'll be able to generalize the solution to search multiple columns.