How to remove Carriage Return from string?

• neilswart

  Mr or Mrs. 500

  Points: 505

  More actions

  May 28, 2003 at 2:14 am

  #159953

  How can I remove Carriage Return -> char(13)

  from a normal string

  in tsql because I don't succeed with the replace function eg.

  SELECT REPLACE(CHAR(13), mystring, '')

• GRN

  Hall of Fame

  Points: 3260

  More actions

  May 28, 2003 at 2:28 am

  #458766

  you have the parameters switched wrong

  also it might be a good idea to out the newline character too

  REPLACE(REPLACE(mystring,CHAR(13),''),CHAR(10),'')

• neilswart

  Mr or Mrs. 500

  Points: 505

  More actions

  May 28, 2003 at 2:33 am

  #458768

  Thanks a lot for that information,

  I switched my parameter wrong here but not in the actual try but you are right it was because of the line feed : char(10)

• mark.rote

  Newbie

  Points: 1

  More actions

  March 27, 2015 at 8:58 am

  #1786935

  This is fine but it removes all carriage returns and linefeeds, even ones you want to keep... Is there a solution for this?

  SET line1 = 'line1'

  SET line2 = 'line2'

  SET lines = line1 + CHAR(13) + CHAR(10)

  SET lines = lines + line2 + CHAR(13) + CHAR(10)

  SET lines = REPLACE(REPLACE(lines, CHAR(13),''), CHAR(10),'')

  lines = line1line2

  not ...

  line1

  line2