What carriage return char string do I need to join 2 text values together?

• martin.godfrey

  Newbie

  Points: 5

  More actions

  June 16, 2008 at 7:49 am

  #192292

  I have a excel spreadsheet with many columns. I want to join 2 columns together and put a carriage return between them. The file is then converted to a text file & imported to SQL d/b - what is the char value for the carriage return? Char(10) only puts a small square as the value

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  June 16, 2008 at 9:32 am

  #829290

  char(13)

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  June 16, 2008 at 11:05 am

  #829352

  In ASCII text, Windows systems, we often have carriage return (CR) and a line feed (LF). Unix can be different.

  Look up ASCII codes and experiment. CHR(13) should work, but Excel might do different things with different data.