Prevent truncating of spaces on end

• Charlottecb

  Hall of Fame

  Points: 3932

  More actions

  October 30, 2003 at 1:45 am

  #81447

  Hi, I have a stored proc that returns rows from my db. I want one of the columns to be returned as the column + ' ' [a space on the end] but SQL always cut the space off. Any ideas on how to stop this.

  TIA

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  October 30, 2003 at 1:53 am

  #480247

  Have a look at BOL 2000:

  SET ANSI_PADDING