Problems converting numeric to varchar

[majorbroncosfan]

I am trying to convert numeric information for a SQL database into the signed equivalent for a COBOL mainframe database. For example, the number 12345 would be converted to 1234E. Due to this fact, I need to be able to convert the column to a one that accepts characters. When I try to do the conversion, the system tells me I cannot. I am outputting the database as a flat file for COBOL. How can I do this?

 

[tlbroadbent]

How are you doing the conversion? Are you using SQL string functions? Are you doing the conversion in T-SQL? Are you using a stored procedure, a view, DTS, or something else? If you have a query, SP or script could you post it? And let us know the version of SQL Server.

Thanks, Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[majorbroncosfan]

I am utilizing the ALTER TABLE statement from SQL Server DTS, but am running this in VB 6.0 through the DTS object.