SQL Server Full text search

• Ashok Jebaraj

  Ten Centuries

  Points: 1215

  More actions

  August 10, 2008 at 10:57 pm

  #190896

  Hi,

  I am new to full text search. I have some questions.

  1. Does SQL Server full-Text search, search only on text data or can it search on Binary data?

  2. There are many ways to stores files in SQL Server. Can Full-text search, search the content of the document? If yes...how do we implement this.

  Ashok Jebaraj

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  August 11, 2008 at 7:07 am

  #856049

  To answer you're questions

  1) Yes, you can also search on BLOB data and documents like .doc or .pdf files stored in your database.

  2) Implementing it is pretty easy, though you have to become familiar with some new concepts and syntax. See here[/url] for more info.

  [font="Verdana"]Markus Bohse[/font]