How to convert LONG to CHAR?

Hi,

I am trying to format several columns from an Oracle table into a formatted text. One column is of data type LONG. I tried to concatenate all columns with ||'s and some text in between, (like:
select
 myLong ||chr(13)||'someText'
FROM
 myTable;
)
but it seems I cannot mix varchar and long. Is there a conversion function?

Alternatively, when issuing a select statement like this: select
 myLong,'someText'
FROM
 myTable;
I get the 'someText' _before_ the output from the long field!?

Thanks a lot for your help!

Helmut Received on Fri Mar 10 2000 - 06:59:43 CST