FINDNOTIN

Restriction: This topic applies to Windows environments only.
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.

Parent topic: String Functions