HiRDB database has equivalent for INSTR function. SQLWays change instr function to POSSTR function with the same arguments.

Oracle:

SELECT INSTR('CORPORATE FLOOR','OR', 3, 2) FROM t;  

HiRDB:

SELECT POSSTR('CORPORATE FLOOR','OR',3,2) FROM t;