export

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  January 28, 2011 at 2:30 pm

  #146978

  how can i export data to a text file in which my bit operators appear as 1 or 0 but not "true" "false".

• Randy Knight

  SSC-Addicted

  Points: 468

  More actions

  January 28, 2011 at 3:04 pm

  #1279981

  CONVERT/CAST or CASE it out in the select statment for the export.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  January 28, 2011 at 3:17 pm

  #1279989

  CASE them out using a TSQL statement.

  Thank You,

  Best Regards,

  SQLBuddy