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
Dig Deeper on Microsoft SQL Server Installation
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.