Hi Thomas,

"Thomas Steinmaurer" <ts@i...> wrote:

> > My problem is that I do not know how CR/LF is represented in
> > SQL.
>
> As Helen said, the general solution is using an UDF.

Can you please correct me, if I'm wrong (did you see
my reply?):

IMHO the problem only arises in environments where it is
difficult to send the actual 0x0d 0x0a bytes to the DBMS,
like ISQL.

When using DSQL from C (or Delphi, or Python, ...), it's
perfectly O.K. to embed the 0x0d 0x0a in the DSQL string
sent to the server. And for this task you can use the
escaping mechanism provided by the programming language
of your choice.

Regards,
Peter Jacobi