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
 Transact-SQL (2008)
 Sql server Full text search Question

Author  Topic 

sqlUser_1
Starting Member

2 Posts

Posted - 2010-03-23 : 16:58:46
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 -