I try the following SQL query :
SELECT FirstName, SecondName FROM Persons WHERE CONTAINS(FirstName, 'Mat')
and I got this error :
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Person' because it is not full-text indexed.
Does I need to index the
FirstName column ? What's wrong ?