Contains/Freetext multiple column specification

Question

I have searched (ironically given this is search server) high and low for reasonable documentation on search server and have come up snake eyes. In particular the proper definition for CONTAINS and FREETEXT with regards to multiple properties/columns.

 

SQL specifies that multiple columns as something like this:

 

CONTAINS( (column1,column2,column3,etc), 'searchterm' )

 

Using that form in the search server query results in an error.

 

Anyone know where I can find the correct documentation for this?

 

Thanks.

Answer 1

The MSS documentation refers you to the Sharepoint search documentation for what you are looking for.  Here is the correct page.  Unfortunately, many of the examples on the page seem to be incorrect.  For example, the doc says you can do something like CONTAINS('computer' AND 'software').  When I do this, I get an error telling me my query is malformed.  The syntax, CONTAINS('computer and software') does seem to work in that it finds documents that contain both computer and software.  This syntax is not shown in the examples, but it does seem to work.

Answer 2

This will work fine. Check any Noise words are there in search string. Any information you need, mail me back to [e-mail]


Noise words will not index-able and not search-able..

Many Thanks,
Guru Bhaskar Mulinti.

Answer 3

Give Query like...  select * from content where contains((title,DESCRIPTION),'"guru"')