Friday, January 07, 2005

INSTR function

The instr function can be used to find if the given string is present in a particular column or not.
Example for this is given below.

SQL> SELECT ename
FROM emp
WHERE instr(ename , 'LL')>0;

ENAME
----------
ALLEN
MILLER

Using INSTR will be much faster than using like in these kind of scenarios.


No comments: