Ann wrote :

<SNIP>

>> However, SQL (to the best of my knowledge) does not. I am loath to
>> plunge into that particular quagmire without some clue how other
>> systems handle the problem.

In Oracle, it can be done with the CHR(n) function as in :

SELECT 'Hello' || CHR(13) || CHR(10) || 'World' FROM DUAL;

or

INSERT INTO TABLE_NAME (FIELD_NAME) VALUES (SELECT a_line_of_text || CHR(13)
|| CHR(10) FROM some_other_table);

On my Unix boxes I get a 'blob' for the CHR(13) but that's one of those
things !

Hope this helps.

Norman.

----------------------------------------------------------------------------
----
Norman Dunbar EMail: NDunbar@...
Database/Unix administrator Phone: 0113 289 6265
Lynx Financial Systems Ltd. Fax: 0113 201 7265
URL: http://www.LynxFinancialSystems.com
----------------------------------------------------------------------------
----