Hi

Question about full-text search, i have set up a table with two collumns, title and body

I have added a full-text to include both columns.

Now i want to search "google"-style in both columns but i cant get a hit from both at the same querie.

The table include a post: title=abc123, body = xyz987

select title from table where contains((title,body), 'abc123 and xyz987') is not working

select title from table where contains((title,body), 'abc123) is working and

select title from table where contains((title,body), 'xyz987') is working

How can i get FT to return hits from two different columns?

/bjorn

looc:

select title from table where contains((title,body), 'abc123 and xyz987') is not working 

select title from table where contains((title,body), 'abc123) is working and

select title from table where contains((title,body), 'xyz987') is working

Hi looc,

I think we should change the query to:

select title from table where contains((title,body), ' “abc123” and “xyz987” ')

Please refer to the following links for more detail:

CONTAINS (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms187787.aspx

Enabling Full-Text Search in your Text Data
http://www.asp.net/learn/sql-videos/video-115.aspx