IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Searching with the Boolean operator NOT

You can use the Boolean operator NOT to exclude particular text documents from the search:

SELECT AUTHOR, TITLE
        FROM DB2EXT.TEXTTAB
        WHERE CONTAINS(COMMENT, 
                             '("author", "pulitzer") & NOT "book"') = 1

This example excludes any text documents containing the term "book" from the search for "author" or "pulitzer".


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]