Replacing Characters

From: <>
Date: Thu, 11 Sep 2008 10:06:50 -0700 (PDT)
Message-ID: <>


We have some messages stored in a column in this format: AA|BB|CC|DD

What we want is to replace the vertical bars with a CHR(10) for line feed, but have 3 leading spaces.

Everything I try seems to only indent the first item 3 characters. Even I try to replace it with ' ' || CHR(10) and it ignores the spaces.......

Ideas anyone? Received on Thu Sep 11 2008 - 12:06:50 CDT

Original text of this message