CHARACTER INDEX


SQL Server

SELECT CHARINDEX('WORD', 'FIND WORD IN THIS SENTENCE.')
Returns 6 (WORD starts in the 6th position of the sentence.)

Oracle

SELECT INSTR('FIND WORD IN THIS SENTENCE', 'WORD') FROM DUAL;
Returns 6 (WORD starts in the 6th position of the sentence.)

This free website was made using Yola.

No HTML skills required. Build your website in minutes.

Go to www.yola.com and sign up today!

Make a free website with Yola