Hi Peter,

> Now I am confused. If I'm not totally out of sync,
> this is a method to return the data single-column, just
> extend the query above to:

>> > "SELECT last_name || '\x0d\x0a' || first_name || '\x0d\x0a' ||
> phone_ext
>> > FROM phone_list \
>> > WHERE location = 'Monterey' ORDER BY last_name, first_name;";

does this really work for you?
When I try the following query with FB 1.5:

SELECT '123' || '\x0d\x0a' || '456' FROM RDB$DATABASE

I get the following result:

123\x0d\x0a456

So the '\x0d\x0a' ist not treated as CR/LF.
Thomas' solution worked, it returned one single column with
a CR/LF in it.


Christian