| ANSI | DB2 | SQL/DS | XDB |
|---|---|---|---|
| X |
Searches for charexpr2 in charexpr1 and returns the offset from beginning of string when found. The format appears below:
FINDSTR(charexpr1, charexpr2)
For example:
FINDSTR("abcdef", "cd") = 3
A return value of zero means not found, 1 is the first character, etc.