|
Home > Archive > IIS Index Server > July 2004 > How to use contains
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to use contains
|
|
|
| Any one have sample how to write query to return result set like option
Advanced query of Indexing service Query Form in MMC.
When I try the following query,
- Select title from scope() where CONTAINS("abd and def")
the result return nothing, on the other hand, MMC return adb AND def result
set (document contain both abd and def) when I put "abd and def" in the
search box of Indexing service Query Form with advanced query option.
Thanks,
Jeab
| |
| Franck Quintana 2004-06-29, 8:45 pm |
| WHERE (CONTAINS(programname,'test'))
| |
| Mahender 2004-07-12, 5:56 pm |
|
You need to enclose the words abd & def in single quotes like:
CONTAINS("'abd' and 'def'")
"Jeab" wrote:
> Any one have sample how to write query to return result set like option
> Advanced query of Indexing service Query Form in MMC.
>
> When I try the following query,
>
> - Select title from scope() where CONTAINS("abd and def")
>
> the result return nothing, on the other hand, MMC return adb AND def result
> set (document contain both abd and def) when I put "abd and def" in the
> search box of Indexing service Query Form with advanced query option.
>
>
>
> Thanks,
>
> Jeab
>
>
>
|
|
|
|
|