Line Break in T-SQL

nashak@hotmail.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,

Sep 15 '06 #1

Alexander Kuznetsov

SELECT 'asdfasd'+char(13)+'ASDF ASF ASDF ASD'

maybe it's CHR not CHAR

Sep 15 '06 #2

Dan Guzman

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.comwrote in message
news:1158285904.128023.10670@e3g2000cwe.googlegrou ps.com...

Sep 15 '06 #3

Hugo Kornelis

On 14 Sep 2006 19:05:04 -0700, nashak@hotmail.com wrote:
Hi Nashak,

In addition to the answers already given by Alexander and Dan, here's
another option - just use a newline character inside a string constant.

For example:

SELECT 'First line
Second line.'

This will show the output on two lines (make sure to select output to
text, not output to grid - the grid doesn't handle newlines too well).

If the data comes from columns, try

SELECT Column1 + '
' + Column2
FROM YourTable
WHERE ....

--
Hugo Kornelis, SQL Server MVP

Sep 17 '06 #4