CODEWITHSUNDEEP
sqlsql-server-2008full-text-search
Bohdan
Bohdan

Reputation: 8408

How can I get filtered query string in MS SQL Server 2008?

I'm using MS SQL Server 2008 EXPRESS R2 built-in full-text search feature CONTAINS(). I know that it filters query string and doesn't search for words like and, or also I noticed that it filters special characters like /, \. When I'm displaying search results I want to highlight matched words so I need filtered query that was used for search and not the original one. Is it possible?

Upvotes: 0

Views: 659

Answers (1)

Martin Smith
Martin Smith

Reputation: 453406

You could take a look at sys.dm_fts_parser

SELECT display_term
FROM sys.dm_fts_parser (' "know that it filters query string and doesn''t search 
                        for words  like and, or also I noticed that it filters
                        special characters like /, \" ', 1033, 0, 0)    
WHERE special_term='Exact Match'

Upvotes: 1

Related Questions