Replacing Strings

From: <>
Date: Thu, 11 Sep 2008 10:17:19 -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.......

What we want is:


Ideas anyone? Received on Thu Sep 11 2008 - 12:17:19 CDT

Original text of this message