double quotation around a comma

• mkey

  Say Hey Kid

  Points: 682

  More actions

  January 28, 2002 at 7:15 am

  #77770

  Hi all,

  I am using BCP utility to export and import data.

  The column data look something like this:

  Col_one(varchar) = 'My string contain comma 2,'

  When I use BCP I'm using $ delimited and some how SQL Server 7.0 is putting a double quotation around the comma. Something like this:

  $My string contain comman 2","$

  How can I elimated these two double quatation?

  Thank you!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734449

  More actions

  January 28, 2002 at 10:35 am

  #422741

  I'd do a replace after the BCP. Look for "," and replace it with ,.

  This is the simplest way.

  Steve Jones

  steve@dkranch.net