| ANSI | DB2 | SQL/DS | XDB |
|---|---|---|---|
| X |
Finds the offset of the first character in charexpr1 that is not in charexpr2. The format appears below:
FINDNOTIN(charexpr1, charexpr2)
For example:
FINDNOTIN("abdblm","dba") = 5
because "l" is the first character not in the "dba" set. A return value of zero indicates all characters are in the string.