Which function is used to perform a full text search on a column?

 Posted by Abhisek on 2/25/2010 | Category: Sql Server Interview questions | Views: 3241

FREETEXT function can perform a full text search on the specified column.

FREETEXT({column/*}, search-string)

It will return the rows with columns that match the search-string. It matches the meaning only not the exact value of the search-string.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response