Previous Topic Next topic Print topic


FINDSTR

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.

Previous Topic Next topic Print topic