Question

Consider the string: "Database Management System". Write suitable SQL query for the following:

Display the position of the first occurrence of "base" in the given string. 

Answer 1

SELECT INSTR('Database Management System', 'base');