how to go new line - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

how to go new line

Author

Topic

myheart46
Starting Member

13 Posts

Posted - 2003-12-02 : 05:06:07

i build formular in report builder then return values
example....
return('a'||'b')
it return values 'ab'
if i need to return
a
b

a at same line but b at next line (same /n in pascal language)
how to return
ps.. i need 1 return not 2 return to 2 label
help me plzzz thx :(

SamC
White Water Yakist

3467 Posts

Posted - 2003-12-02 : 07:55:12

return('a' + + char(13) + char(10) + 'b')

myheart46
Starting Member

13 Posts

Posted - 2003-12-02 : 20:57:45

thx u i'll try
but i want to know what is 'char(13)' and 'char(10)' mean?
and what is '++' and '+' mean?
i try to ues yr command in sql plus
if i select 'a'++char(13)+char(10)+'b' from dual
it said missing expression

myheart46
Starting Member

13 Posts

Posted - 2003-12-02 : 21:08:22

i try it in report builder but it can't T_T
it said no function with name char exists in this scope

myheart46
Starting Member

13 Posts

Posted - 2003-12-03 : 01:37:24

i know it already
it use chr(10) to feed line
but anyway thx u for information

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-12-03 : 12:26:24

myheart46, you keep mentioning sql plus (noticed it in another thread of yours). This is a SQL Server site.

Tara