Question

If the substring is not present in a string, the INSTR() returns ______.

Options

• −1

• 1

• NULL

• 0

Answer 1

If the substring is not present in a string, the INSTR() returns 0. 

Explanation:

The INSTR function will return 0 if the string contains no substrings.