Date: Thu, 11 Sep 2008 10:17:19 -0700 (PDT)
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