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.
FREETEXT ( [Column_Reference, ] 'Free_Text_String ') > 0 [ Boolean_Operator FREETEXT ( [Column_Reference, ] 'Free_Text_String ') > 0 ]...
| 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. |
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 02:23, local time: 2025/1/4 03:31,
3.137.181.194: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? <A HREF="http://ecomorder.com/techref/language/asp/ix/ixsefre.htm"> SQL Access to Index Server Data: FREETEXT Predicate</A> |
| Did you find what you needed? |
Welcome to ecomorder.com! |
Welcome to ecomorder.com! |
.