There's a missing pipe (bar) on the second concatenator.

select a_col||chr(10)|b_col from your_table;

But chr(10) is for a new line.

[Edited by stecal on 06-14-2002 at 03:14 PM]