String function

[dkandpal]

HI


I need to select all the records from a column that has exactly two 'A'. No matters where they appear in the atring.

Any predefined or new function can be used.

Kindly advice

Thanks

[ahmadbilal]

use instr() function

The "in string" functions search string for substring. The function returns an integer indicating the position of the character in string that is the first character of this occurrence.


<b>http://www.psoug.org/reference/substr_instr.html</b>

<b>http://download-west.oracle.com/docs/cd ... 55a.htm</b>