In regards to this SQL Server Full text Search subject, I possibly could save my files in binary data type and my problem was solved.

Now, after saving files within the database I've got a new problem.

After searching, I have to find the position of the criteria (For instance by which lines or which posts) and highlight individuals.

I guess this is essential that we are able to find the position of the criteria text in files and demonstrate to them towards the customers.

I appreciate any help.

Till SQL Server 2005, I do not think there's any built-in function with this.

Anyways, take a look at Christopher Felpel (VB.Internet based) solution for highlighting the search string -