Functions

INSTR

This function helps to search in a given string.

INSTR(trim(cp.PARAMETERVALUE), trim(ft.CODE) || ',' ) > 0)

Here || is NOT or function. It or only in Java. In SQL it is append.

COALESCE

The coalesce function returns the first non-null expression in the list.