Reference Guide > Function Support for Data Sources > Function Support Issues when Combining Data Sources > INSTR Function
 
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.