Add/Remove NewLine in SQL Query « WiseCodes : Bringing You The Power of Code !!

Add/Remove NewLine in SQL Query

Posted By Venu Thomas

Add NewLine in SQL Query:

Code:

Declare @FristName Char(10)
Declare @LastName Char(10) 
 
Set @FristName = 'Venu'
Set @LastName = 'Thomas' 
 
Select (@FristName + CHAR(13) + CHAR(10)+ @LastName) As Name

OutPut:

Name
———————-
Venu
Thomas

(1 row(s) affected)

Remove NewLine in SQL Query:

Code:

^?View Code SQL

 Declare @FristName Char(5)
Declare @LastName Char(10) 
Declare @strName Char(15) 
 
Set @FristName = 'Venu'
Set @LastName = 'Thomas'  
 
Set @strName =@FristName + CHAR(13) + CHAR(10)+ @LastName 
 
Select Replace(Replace(@strName, CHAR(13), ''), CHAR(10), ',') As Name

OutPut:

Name
————
Venu ,Thomas
(1 row(s) affected)

Share on Facebook

Tags: SQL

This entry was posted on Friday, February 13th, 2009 and is filed under SQL.

Share with others:

Thanks for visiting us! If you enjoyed these icons please feel free to share them! Or if you want to know what's going on with WiseCodes.com, follow us!