Full Text Indexes with SQL Server 2008R2

Yah we have possibility of searching option in traditional T-SQL Language but Full Text Indexing much more powerful then T-SQL Language statement using Such as “LIKE”

Ex:-

USE AdventureWorks2008R2
GO

SELECT DISTINCT FirstName
FROM Person.Person
WHERE FirstName LIKE '%bert%'

The Result Was

Yah, we know the LIKE Operator in T-SQL is a Very Powerful Operator and its Finding String Value within strings.

It’s a pattern-based search, but there is big difference between searching for Substrings and searching for works.

The LIKE Operator is to search for Substring within Strings

And we have considered about Performance. An Index on a column is ignored when you are searching for values using pattern with a leading %wildcard