INSTR Function

If INSTR is executed in TDV, it returns NULL for INSTR('','C') and 0 for INSTR(' ','C').

Note: The difference is a space character. The C character is just an example.

When pushed to some databases, INSTR('','C') might return 0 instead of NULL.

Top