Re: String parse help in Oracle

From: Brian Tkatch <N/A>
Date: Wed, 07 Nov 2007 15:10:05 -0500
Message-ID: <kr64j3p55mrfmrm7cj720ei0rnlpi1bd7v@4ax.com>

On Wed, 7 Nov 2007 10:20:37 -0800, "CK" <c_kettenbach_at_hotmail.com> wrote:

>How can I search a string supplied by a user for the first occurrence of a
>letter that is also supplied by a user; once you find the letter display its
>position within the string.
>
>Also I would like to modify the script above so that the string is searched
>for all occurrences of the letter. For each occurrence of the letter,
>display its position within the string.
>
>Thanks for any help or examples of how to do this.
>
>V/R,
>ck
>

It sounds like you want to use the INSTR FUNCTION. It is described in the SQL Reference.

B. Received on Wed Nov 07 2007 - 14:10:05 CST