Difference between revisions of "OCCURS()"

Revision as of 05:56, 25 October 2011

Purpose

Function to return the number of times a specified character expression occurs within another specified character expression.

Syntax

OCCURS(<expC1>,<expC2>)

See Also

AT(), ATNEXT(), INLIST(), LEFT(), RAT(), RIGHT(), SET STRESCAPE, STR(), STREXTRACT(), STRTRAN(), STUFF(), SUBSTR()

Description

The OCCURS() function returns the number of times the character expression <expC1> is found in character expression <expC2>. A value of zero is returned if <expC1> does not exist in <expC2>. The character matching is case sensitive.

Example

? occurs("a", "Recital DAO Classes for Java")
         4

Products

Recital, Recital Server