You can use the wrap function to translate carriage returns.
print $test (+1,1) wrap 50 5000 strip=<13> on=<10>
(From SQR Help)
The STRIP and ON arguments affect which characters are to be converted before wrapping, and which characters will force a wrap to occur.
Characters in the STRIP string argument will be converted to spaces before the wrap occurs.
Characters in the ON string argument will cause a wrap at each ON character found. The ON character will not be printed.
Both arguments will accept regular characters plus non-display characters whose ASCII values are surrounded by angled brackets, <nn>.
-----Original Message-----
From: Jason Wainwright [mailto:JasonW@LIMON.CO.ZA]
Sent: Wednesday, January 05, 2000 5:36 AM
To: SQR-USERS@list.iex.net
Subject: Printing Memo Objects
Hi all
From the Database I read a field that is varchar(250), only thing is, is
that it has the enter character in it. How do I print a string with these
in, on screen (.SPF) it displays the two solid bars (extended acsii I
think), when i print it it carriage returns. The system is Win 95 and
Sybase and Worbench v4.1.
Any simple solutions?
TIA