please dont rip this site

FREETEXT Predicate

A FREETEXT query performs a best match of the specified words and phrases. It works by finding rows in which the terms and phrases match the meaning, rather than the exact wording of the query. A FREETEXT query ignores Boolean, proximity, and wildcard operators.

Note: It is illegal to place NOT before a FREETEXT predicate that begins with a WHERE clause.

Syntax

FREETEXT ( [Column_Reference, ] 'Free_Text_String ') > 0
[ Boolean_Operator FREETEXT ( [Column_Reference, ] 'Free_Text_String ') > 0 ]...

Elements

Column_Reference   Specifies the column name (alias). Its data type must be compatible with the format of the Free_Text_String specified.
   
Free_Text_String   Specifies the literal of type Basic String to match the meaning from.
   
Boolean_Operator   Specifies the boolean operator to use, following the precedence rules previously stated, that combines the FREETEXT predicates.

Examples

The following example returns files in which the Contents mention Microsoft Excel, printing worksheets, and pasting worksheets.

...WHERE FREETEXT('how do I print in Microsoft Excel') > 0
     OR FREETEXT('how can I paste a worksheet into another file') > 0

© 1997 by Microsoft Corporation. All rights reserved.
file: /Techref/language/asp/ix/ixsefre.htm, 3KB, , updated: 1997/9/29 03:23, local time: 2025/5/9 06:31,
TOP NEW HELP FIND: 
18.224.184.62:LOG IN
 ©2025 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?
Please DO link to this page! Digg it! / MAKE!

<A HREF="http://www.piclist.com/techref/language/asp/ix/ixsefre.htm"> SQL Access to Index Server Data: FREETEXT Predicate</A>
After you find an appropriate page, you are invited to your to this massmind site! (posts will be visible only to you before review) Just type a nice message (short messages are blocked as spam) in the box and press the Post button. (HTML welcomed, but not the <A tag: Instead, use the link box to link to another page. A tutorial is available Members can login to post directly, become page editors, and be credited for their posts.


Link? Put it here: 
if you want a response, please enter your email address: 
Attn spammers: All posts are reviewed before being made visible to anyone other than the poster.
Did you find what you needed?
  PICList 2025 contributors:
o List host: MIT, Site host massmind.org, Top posters @none found
- Page Editors: James Newton, David Cary, and YOU!
* Roman Black of Black Robotics donates from sales of Linistep stepper controller kits.
* Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters.
* Monthly Subscribers: Gregg Rew. on-going support is MOST appreciated!
* Contributors: Richard Seriani, Sr.
 
Quick, Easy and CHEAP! RCL-1 RS232 Level Converter in a DB9 backshell
Ashley Roll has put together a really nice little unit here. Leave off the MAX232 and keep these handy for the few times you need true RS232!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  .