position Function in DB2

In IBM DB2, the POSITION function is used to find the position of a substring within a string. It returns the position of the first occurrence of the substring within the string, starting from 1. If the substring is not found, it returns 0.

Here's the syntax of the POSITION function in DB2:

POSITION(substring IN string)

- substring: The substring to search for within the string.

- string: The string in which to search for the substring.

Example:

SELECT POSITION('world' IN 'hello world') AS position FROM sysibm.sysdummy1;

This will return 7, indicating that the substring 'world' starts at the 7th position within the string 'hello world'.