Previous Topic Next topic Print topic


FINDANY

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.

Previous Topic Next topic Print topic