Previous Topic Next topic Print topic


FINDNOTIN

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.

Previous Topic Next topic Print topic