On Wed, 13 Aug 2003 18:28:09 +0000 (UTC), julien_ferraro wrote:

> I would like to create a query that returns an address.
> i could do
>
> select ADDRESS, ZIP_COPDE, CITY
> from MYTABLE
> ...
>
> but i would like to get the data show in that way
>
> Address Line 1
> Address line 2
> ZipCode City
>
> so i would like to know what is the way to select the CR/LF sequence in a
> select clause
>
> if could be
>
> select ADDRESS || <CRLF> || ZIP_CODE || ' ' || CITY
> from MYTABLE
>
> My question is : How to write the <CRLF> part of the select clause ?

You could try:

select ADDRESS || '
' || ZIP_CODE || ' ' || CITY
from MYTABLE


--
Aage J.