Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

CONTAINS

The CONTAINS function searches for text in a particular text document. It returns the INTEGER value 1 if the document contains the text. Otherwise, it returns 0.

Function syntax

>>-CONTAINS--(--handle--,--search-argument--)------------------><
 

Function parameters

handle
An expression whose result is a value of type DB2TEXTH or DB2TEXTFH. It is usually the name of a handle column containing the handles of the text documents to be searched.

search-argument
A string of type LONG VARCHAR containing the terms to be searched for. See Chapter 10, Syntax of search arguments.


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