INSTR

=INSTR=

SYNTAX
INSTR(str, chars[,s[,n]])(str, chars[,s[,n]] = =

Description
The INSTR function finds the numerical position of a named character. This meaning that when you input a letter they will find the value. This value will be a numeric answer

EXAMPLE:
//SELECT// INSTR('HelloWorld','W') FROM dual


 * INSTR('HELLOWORLD','W') ||
 * 6 ||

//SELECT// INSTR('HelloWorld','d') FROM employees
 * INSTR('HelloWorld','d') ||
 * 10 ||

//SELECT// INSTR('HelloWorld','r') FROM f_staffs
 * INSTR('HelloWorld','r') ||
 * 8 ||