How to implement full-text search in sqlserver

Question

I am using autocomplete for my websiteso i want to implement full-text search in applicationso tell me the best approach to write query.

Sandeep Shekhawat · Answer

http://www.c-sharpcorner.com/UploadFile/nipuntomar/FullTextSearch07302007051335AM/FullTextSearch.aspx http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/ B y above Link there author is : 1) Nipun Tomar 2) pinaldave F orm Nipun Tomar article write first of all in ur database query window: exec sp_fulltext_database 'enable' It will enable your database for full text search then after it u follow pinaldave blog steps: at last write this query select * from adminlogin where freetext(*'admin') Here adminlogin is table name that is enable for full text search and 'admin' is a word that i will be search. u can pass this word from your textbox as parameter via storeprocedure to query. OUTPUT Will Be