SELECT INSTR('apple banana citrus drupe escarole fig', 'fig',1) "fig-at" from dual

PostgreSQL : does not have instr may be done with a function  "position",

SELECT position('fig' in 'apple banana citrus drupe escarole fig') "fig-at"

MySQL

SELECT INSTR('apple banana citrus drupe escarole fig', 'fig') "fig-at"