I have the following sql server query
SELECT *
FROM [dbo].Client
WHERE FullName LIKE '%Lind%'
Which returns the following row:
When I run the following Full Text Search query that row is not returned
SELECT *
FROM [dbo].Client
WHERE FREETEXT(FullName, 'Lind')
Why does this happen? FREETEXT is supposed to match and return this row.