Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > String Functions > FINDANY

FINDANY

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
      X

Searches for any of the characters specified by charexpr2 in charexpr1 and returns the offset from the beginning where the first occurrence is found. The format appears below:

FINDANY(charexpr1, charexpr2)

For example:

FINDANY("abcdef","zd") = 4

because "d" is found at the fourth character. A return value of zero signifies not found.

Parent topic: String Functions
Previous Topic Next topic Print topic