On 5 Nov 2003 at 8:08, Tim Ledgerwood wrote:

>How would I write a query or a stored procedure to insert non - printable
>characters in a table?

If you need CRLF only, I know the way.

>How would I write a trigger or stored procedure to insert a CRLF (Ascii 13
>Ascii 10) into the EOL field?

CREATE PROCEDURE AAA AS
BEGIN
.....
INSERT INTO MYTABLE (MYNAME, EOL)
VALUES ('string','
');
.....
END

You must run it from script or any other tool which doesn't
eliminate line separators from query text.

SY, Dimitry Sibiryakov.