SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using INSTR to find spaces

447543Aug 23 2005 — edited Aug 24 2005

Hi,

I am trying to get the position of the first space in a string, but it doesn't seem to recognise the space - can anyone help?

I have tried:

INSTR(lv_stringname, ' ', 1, 1); and INSTR(lv_stringname, ' &nbsp', 1, 1);

Any ideas, anyone? :)

Cheers,
angel

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2005

Added on Aug 23 2005

13 comments

8,786 views