IBM Books
(C) IBM Corp. 2000

DB2 Net Search Extender Administration and User's Guide

Numeric attribute search

On numeric attributes that are stored in a structured document, you can search using the following syntax:

SELECT AUTHOR, TITLE
        FROM DB2EXT.TEXTTAB
        WHERE CONTAINS(COMMENT,
        'ATTRIBUTE "PRICE" between 9 and 20') = 1  
 

Note that attribute names are case-sensitive. Ensure that the attribute name in the model file and in the query are identical. See Chapter 9, Working with structured documents for more information.


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