| 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.