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 2005 Forums
 Transact-SQL (2005)
 Escap sequence..

Author  Topic 

8022421
Starting Member

45 Posts

Posted - 2009-06-08 : 05:41:06
Could any one please tell me what escape sequence can be used to display the data in the next line in sql

Eg

select 'dhana ??? sekar

Output

dhana
sekar

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-08 : 05:48:27
+ CAHR(13) + CHAR(10)

Carriage Return (13) + LineFeed (10)


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -