Active Server Corner
Quick Site Search
What's Inside
Home
Activity
Books
Excerpts
In-Depth
CodeLibrary
Columns
ActiveTalk
COMSutra
Cornered!
My 3 Cents
Square ONE
Downloads
Events
FAQ's
Jobs
Search
Tools
Product Reviews
Tutorials
Site Info
About Us
Advertising Info
Contact Us
Privacy Policy
Terms of Use
Write for Us
  Search Active Server Corner  

Index Server Query Language

Using the Search Criteria Boolean Search (Step #2), you can build a query using the advanced Search syntax of Microsoft Index Server. Highlights follow!

Boolean and Proximity Operators

Boolean and proximity operators can be used to create a more precise query. 

To search for

Example

Results

both terms in the same page  access and basic 
-or-
access & basic 
pages with both the words "access" and "basic" 
either term in a page  cgi or isapi 
-or-
cgi | isapi 
pages with the words "cgi" or "isapi" 
the first term without the second term  access and not basic 
-or-
access & ! basic 
pages with the word "access" but not "basic" 
pages not matching a property value  not @size = 100 
-or-
! @size = 100 
pages that are not 100 bytes 
both terms in the same page, close together  excel near project 
-or-
excel ~ project 
pages with the word "excel" near the word "project" 

Hints:

  • You can use parentheses to nest expressions within a query. The expressions in parentheses are evaluated before the rest of the query.
  • Use double quotes (") to indicate that a boolean or near operator keyword should be ignored in your query. For example, "Abbot and Costello" will match pages with the phrase, not pages that match the boolean expression.
  • The Near operator returns a match if the words are within 50 words of each other.
  • The Not operator can only be used after an And operator in content queries; it can only be used to exclude pages that match a previous content restriction. For property value queries, the Not operator can be used apart from the And operator

Wildcard Operators

Wildcard operators are useful for finding pages with words similar to a given word. 

To search for

Example 

Results

words with the same prefix

comput* 

pages with words that have the prefix "comput", such as "computer", computing", and so on. 

words based on the same stem word

fly** 

pages with words based on the same stem as "fly", such as "flying", "flown", "flew", and so on. 



Miscellaneous Tips on Query Syntax

  • Queries are case-insensitive: you can type your query in uppercase or lowercase.
  • You may search for any word except for those in the exception list (for English, this includes a, an, and, as, and other common words) which are ignored during a search. Words in the exception list are treated as placeholders in phrase and proximity queries.
  • Punctuation marks such as the period (.), colon (:), semicolon (;), and comma (,) are ignored during a search.
  • To use specially-treated characters ( (&), (|), (^), (#), (@), ($), ((), ()) ) in a query, enclose your query in quotes (").

Other Search Avenues


Search Amazon.com


Your ads here
Want to know how you can display ads in this space? Read more about advertising at the Corner.






Copyright © 1997-2000 Active Server Corner. All rights reserved.

Sponsored by Coastline Web Hosting in Santa Barbara, California