Question

Write a SQL query for the following:

To display the position of first occurrence of ‘com’ in the string ‘mycommercial.com’.

Answer 1

SELECT INSTR(‘mycommercial.com’, ‘com’);