Re: put away characters in result of query

You could also as mentioned I think just create a funtion like

Function REPLACE_CHARS
( f_string IN varchar2 )
RETURN varchar2 IS

new_string varchar2(4000) default null;

BEGIN
if f_string is null then
return null;
end if;

new_string := replace('A','');
new_string := replace('B','');

etc...


RETURN new_string;


END; -- Function REPLACE_CHARS

I think that would also solve your problem.

T3

.