Post reply

Find and Highlight keywords in Full Text Search Results

  • August 24, 2010 at 4:34 pm

    #226207

    Hi,

    I am working on the Full Text Search in Sql Server 2005. I have created a catalog and then an index on a particular table.

    I am searching for data in a particular column in that table using FREETEXTTABLE(tablename,COLUMN_NAME,@SearchKeyword).

    After I get the results, I need to show some sample text from the column that contains the keywords and highlight them, is there an easy way to find out where in the column the keywords were found? Is the keyword(s) present in the first 50 characters or 100 characters..? I would appreciate any suggestions.

    Thanks

  • August 31, 2010 at 3:39 am

    #1214116

    I need to show some sample text ed hardy perfume[/url]from the column that contains the keywords and highlight them, is there an easy way to find out where in the column the keywords were found? Is the keyword(s) present in the first 50 characters or 100 characters..? Ied hardy schuhe[/url] would appreciate any suggestions.ed hardy kleidung[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply