Highlighted Result Strings with Full-Text Search in SQL Server

Published by: Sangeeta (1/9/2009 1:42:36 AM)

I have a table where one of the columns contains binary data and I am querying a full-text search on this. I want the search results to be highlighted after the query gets fired. Is there any possible way to highlight the searched results with the help of FTS?
e.g. When we make a Google search, Google gives us a list of search result pages with the search string highlighted in bold.

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

Spacing issue while exporting a MS SQL Report to PDF >>

<< What is the role of sql management objects in sql server?