How to get the substring value from a column with data?

[aspdba]

Originally posted by DaPi
translate(initcap(column),
'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ')
Will deal with any number of names - but I feel there must be a neater way . . .

you are something..!!!

 create table test_to_del
 (
 name varchar2(20)
 );

 insert into test_to_del values ('saM len');
  insert into test_to_del values ('a b');
   insert into test_to_del values ('q v');

select replace(translate(initcap(name),
'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ'),' ','')
from test_to_del;


REPLACE(TRANSLATE(IN
--------------------
SL
AB
QV

drop table test_to_del;