Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Firefox Pilla Bewarse Username: Firefox Post Number: 771 Registered: 12-2004 Rating: N/A Votes: 0 Posted on Tuesday, September 11, 2012 - 3:13 pm:    edo full text search anta with - CONTAINS or FREETEXT Comparing LIKE to Full-Text Search In contrast to full-text search, the LIKE Transact-SQL predicate works on character patterns only. Also, you cannot use the LIKE predicate to query formatted binary data. Furthermore, a LIKE query against a large amount of unstructured text data is much slower than an equivalent full-text query against the same data. A LIKE query against millions of rows of text data can take minutes to return; whereas a full-text query can take only seconds or less against the same data, depending on the number of rows that are returned. http://msdn.microsoft.com/en-us/library/ms142571.aspx