Difference between "CONTAINS" and "FREETEXT" in FULL TEXT SEARCH - SQL Server

"CONTAINS" looks for one word.  Search variable should not be a string with spaces.  Just one word.

"FREETEXT" looks for multiple words. Search variable can have multiple words and it will search on all of them

SinghAmandeep,

Unfortunately, you have chosen to copy and paste without giving any credit from here:
Comparing Full-Text Functions and Full-Text Predicates
http://msdn.microsoft.com/en-us/library/ms142494(SQL.90).aspx

This is a direct violation of EE Guidelines. See here:
https://www.experts-exchange.com/help.jsp#hs=23&hi=605
About copyrights
Copying and pasting a web page or other document is considered copyright infringement in most cases. If you want to refer to someone else's work the preferred method is to post the link with a brief description of it. Posts that consist entirely of work copied and pasted from other sites will generally be deleted unless it's from your own work.

I have asked a Moderator to review.

Any more comments ?

Thanks

Anything specific you're looking for?  

acperkins provided you with a good high level explanation.  
I provided you some high level code on how you'd use in T-SQL.

Are we missing something? :)  

Thanks!

Anything specific you're looking for?  

acperkins provided you with a good high level explanation.  
I provided you some high level code on how you'd use in T-SQL.

Are we missing something? :)  

Thanks!