Monday, 31 July 2017

Remove All New Line & (Feed) From A Variable Or Column In Sql Server

DECLARE @VARIABLE VARCHAR(MAX)=''

SET @VARIABLE= 'Hello Friend 
Thank You So Much For Visit My Blog 
Priyank Gadhiya '

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

No comments:

Post a Comment