EXPERT RESPONSE
What is the structure of the table to start with and what is the DDL you are
issuing to alter the table?
Editor's note: In resonse to Michael's request for more information, the user replied to say that she had resolved the issue. Here is what she said:
I have resolved the issue, I will try to
explain so others may benefit...
The text file had fields created in COBOL as 9(7).9(4)-. The decimal and
sign were hard coded. Every time I tried to create the table with a numeric
column [numeric](13,4) null, and run the following code I got an error.
insert into Table_Name
select
substring(onecolumntable,1,13) as cost,
I found out that SQL Server 2000 does not like the hard coded sign on the
right of the expression so - this is what I did...
insert into Table_Name
select
substring(onecolumntable,13,1) + substring(onecolumntable,1,12) as
Cost
|
