Re: PL/SQL substr(instr oracle

wizofoz2k_at_yahoo.com.au (Nuno Souto) wrote in message news:<73e20c6c.0306191448.217976db_at_posting.google.com>...
>
> this is better than my previous attempt:
>

<groan>

Apologies:

select substr('&STR',1,instr('&STR','_')-1|| translate(initcap(replace(substr('&STR',instr ('&STR','_')),'_',' ')),' abcdefghijklmnopqrstuvwxyz','_') from dual;

<note the subtle difference...>

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Thu Jun 19 2003 - 20:09:50 CDT