|
Posted by Dan Guzman on 09/15/06 12:40
The line terminator on a Windows platform is carriage return/line feed
(ASCII 10 and 13). You can concatenate CHAR(13) + CHAR(10) where you want
line breaks.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<nashak@hotmail.com> wrote in message
news:1158285904.128023.10670@e3g2000cwe.googlegroups.com...
> Hello,
>
> In a Stored Proc, I am building a string variable. I am getting outputs
> from 4 different queries and would like the string to have line breaks
> to display each entry in a different line in a text area. How can I do
> this?
>
> i.e
> result = result1 + result2 + result3 + result4.
> What characters can I enter so that the output is displayed in the
> textarea as
> result1
> result2
> result3
> result4
>
> Thanks,
>
Navigation:
[Reply to this message]
|