You're welcome! and Merry Christmas to you and yours, and may 2013 be
absolutely fabulous for you.
Albert
On 26/12/2012 1:48 PM, Karen Tellef wrote:
Aha! Now why didn't I think of that! Yes, using a VarChar field
preserves the carriage returns! So now the BLOB editor clearly shows
multiple lines of data within that column.
From there I wrote a cursor to step through the value character by
character and test for the CR/LF. Several combinations had to be
tested until I found that a simple CHAR(010) by itself was
recognized. So that will enable me to parse the string!
So far so good, potential project moving forward! Thanks Albert, and
Merry Christmas!
