Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Data conversion during import

Author  Topic  waldo Starting Member 1 Post Posted - 2004-10-10 : 18:43:57 I am importing a text file from a legacy system. This file contains a field that is the paid amount but comes with characters when is a negative value. 000123Y = -12.39. I am planning to create a new field in the table and convert the data into the new field as the correct value. I Need to keep the original data since is history data from a client. What is the best data type for this field? What is the best approach to do the conversion from 000123Y to -12.39? ( Y = -9, T = -8, G = -7... } = -1)