I want to create a string which contains a new line character. In
Powerbuilder, I would
use  '~n'  but what do I use within a stored procedure in ASE 12.0?  I'm
trying to create
a mulit-line error message that is passed back from the stored procedure to
the
Powerbuilder front-end.

select @message = 'Line1~n Line 2 ~n Line 3"  should display like this:
Line 1
Line 2
Line 3

Thanks!

select @message = "Line 1" + char(10) + "Line 2" + char(10) + "Line 3"
select @message

RM wrote:

> I want to create a string which contains a new line character. In
> Powerbuilder, I would
> use  '~n'  but what do I use within a stored procedure in ASE 12.0?  I'm
> trying to create
> a mulit-line error message that is passed back from the stored procedure to
> the
> Powerbuilder front-end.
>
> select @message = 'Line1~n Line 2 ~n Line 3"  should display like this:
> Line 1
> Line 2
> Line 3
>
> Thanks!

If you get this to work, let me know.  I never could get this to work.  The
new line character would cause a new row to be in the result set when it
gets back to the PB datawindow.

Bob Densmore


"RM" <Rosemarie.boarman@starzencore.com> wrote in message
news:65AzA8vtAHA.276@forums.sybase.com...
> I want to create a string which contains a new line character. In
> Powerbuilder, I would
> use  '~n'  but what do I use within a stored procedure in ASE 12.0?  I'm
> trying to create
> a mulit-line error message that is passed back from the stored procedure
to
> the
> Powerbuilder front-end.
>
> select @message = 'Line1~n Line 2 ~n Line 3"  should display like this:
> Line 1
> Line 2
> Line 3
>
> Thanks!
>
>
>

You may need to use CHAR(13) + CHAR(10).  I believe this would be a requirement on the PC 
side but not Unix.
-- 
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com