The minimum required here, as long as you've managed to full-text index this table "PERSON", is:
DECLARE @name [nvarchar](30)
SET @name = 'Barack'
SELECT [FORENAME] FROM [PERSON]]
WHERE CONTAINS( [FORENAME], @name )
That being said, in order to search for this string:
SET @name N'Barack Hussain Obama'
You'd have to be concatenating two fields, ie-> [FORENAME] + [SURNAME], which would quickly make a simple search run through a table of first & last names quite a but more difficult. My solution, as begun, would entail searching through once, for either the FORE or SUR, getting all the results ... tabulating them, then searching again, after making THAT table FULL-TEXT INDEXED, for the second part. I don't see any real logic to trying to concatenate first and last then looping through another table of concatenations ...
Submit an article or tip