Is it possible to use ContainsTable to get results for more than one column?
- by LockeCJ
Consider the following table:
People
FirstName nvarchar(50)
LastName nvarchar(50)
Let's assume for the moment that this table has a full-text index on it for both columns.
Let's suppose that I wanted to find all of the people named "John Smith" in this table. The following query seems like a perfectly rational way to accomplish this:
SELECT…