Hi Alan,

"Alan McDonald" <alan@m...> wrote:

> > "SELECT last_name || '\x0d\x0a' || first_name, phone_ext
> > FROM phone_list \
> > WHERE location = 'Monterey' ORDER BY last_name, first_name;";
>
> but I get a sneeking suspicion that he wants data to be returned in one
> column rather than as rows a la ISQL data returns...
> surely I'm wrong

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;";

Regards,
Peter Jacobi