Removing those extra spaces when exporting to Text File

• Mark Letheren-271369

  Old Hand

  Points: 356

  More actions

  February 26, 2008 at 8:18 am

  #71176

  I must be thick or just not had enough coffee!

  I need to remove the extra spaces after a field when exporting data to a Text File.

  So ..

  "Mark", "Letheren"

  and NOT ..

  "Mark ", "Letheren "

  TIA

• Carolyn Richardson

  SSCrazy Eights

  Points: 8357

  More actions

  February 26, 2008 at 8:26 am

  #782016

  ltrim or rtrim strips spaces L eft or R ight of the field

  Facts are stubborn things, but statistics are more pliable - Mark Twain
  Carolyn
  SQLServerSpecialists[/url]

• Mark Letheren-271369

  Old Hand

  Points: 356

  More actions

  February 26, 2008 at 8:28 am

  #782020

  Thank you for the answer .. there isn't a little check box somewhere that says "Truncate"?

  I have 270 fields to export ....