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]
|
Results 1 to 4 of 4
Threaded View
|
Click Here to Expand Forum to Full Width |