• You could BCP into a staging table as varchar, do some substringing to remove the (-) sign and import into the final table.

    If DTS is an option, you could use ActiveX scripting to remove the (-) sign before loading into your table.


    Joseph