At 5/2/2001 01:44 PM (Wednesday), stephan0h@... wrote:

>Maybe i'm missing the point in this discussion, but why not just
>something like
>
>SELECT 'text'||chr(10) FROM rdb$database;
>
>Of course, to convert control characters in an existing string is
>probably i different story...

That's the point. Chr() is not a standard SQL function in Interbase. You
may be confusing Object Pascal with SQL here.