Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Question on SQL Server Full text search

Author  Topic 

sqlUser_1
Starting Member

2 Posts

Posted - 2010-03-24 : 02:02:20
Hi,

I am using full text search in two of my fields. I want to use exact pharse search. But I don't know how to implement this. Could someone help me.

For example : I want to search 'Windows Arch' on my description field. The data in description field is as follows :

Description
-------------------
This is Windows Arch test 1
This is Windows Arch test 2
Windows Testing Testing Arch

The result should return first two rows, not last row.

Though windows and arch word present in third row, as I want to do a exact pharse search, it should return first two rows.

Could anyone help me on this.

Thanks.
   

- Advertisement -