PL/SQL Question

[Quoted] 	I am trying to replace the ASCII carriage return (chr(13)) with '<br><br>'.  I have tried to use the following code but it won;t work:
       select translate (lp,chr(13),
             breaker)into lp
           from dual;

where 
        breaker := '<br><br>';

How do you replace/translate a string where you replace one character with many? [Quoted] I have tried to put the <br><br> string in for breaker but it replaces char(13) with the < symbol - again a problem with replacing 1 character with many.

Thanks,
Sean Received on Mon Jun 22 1998 - 00:00:00 CEST