Sunday, September 16, 2018

Replace a New Line In T-SQL




/*************************************************
REPLACE A NEW LINE IN T-SQL
***************************************************/

SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')

      

No comments:

Post a Comment