Re: Character function

Try

  1* SELECT INSTR('Im an example','l') FROM DUAL SQL> / INSTR('IMANEXAMPLE','L')

                      12

M

Álvaro Palma Aste <queria_direccion_at_el.perla.invalid> wrote in message news:<acj962$7um$1_at_news.cec.uchile.cl>...
> Hi, anybody knows if is there a function in Forms or PL/SQL that
> returns the position of an specified character in a string?
>
> Something like:
>
> first_position('I´m an example','l') returns 13
>
> so I won´t have to program it again :-)
>
> Thanks a lot
Received on Mon May 27 2002 - 16:15:46 CEST