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 Received on Fri Dec 23 2005 - 09:44:51 CST