SQLCmd Column Separator

• Keith Sibbert

  SSC Veteran

  Points: 205

  More actions

  June 12, 2007 at 4:59 pm

  #174675

  I am attempting to use a tab (Char(9)) as the column separator for outputting to a tab delimited file using sqlcmd and can't set it using any of the traditional values ("\t", char(9), etc.). Anybody know how to go about doing this?

• Eyal Levin

  Valued Member

  Points: 68

  More actions

  January 8, 2008 at 3:20 am

  #765639

  Declare @tab as varchar

  set @tab= char(9)

  use @tab wherever you need

• vsr_mca2

  SSC Rookie

  Points: 25

  More actions

  January 9, 2008 at 5:21 am

  #766103

  use space(9)