Hey Wayne - Based on the 3 digit code in Field7........ I think I am trying to import:

528, 529, 531, 535, 539, 576, 608, 609, 624, 625, 626, 628, 630,...

Thanks Wayne....I really appreciate all your help. It would be nice if I could somehow dynamically perform this for all the record types but I will alter the values for...

Hi Wayne - I think I have attached a file which is the top xxx number of records that I cut and pasted into a txt doc

Hi Wayne - Thanks Again......although I am receiving this error:

(1 row(s) affected)

Msg 536, Level 16, State 5, Line 1

Invalid length parameter passed to the SUBSTRING function.

The statement has been terminated.

(1...

Thank you so much Wayne.....and thank you for the references to the articles. I am new to SQL server so I will certainly take a look.

Also, can I chnage the...

THANK YOU, THANK YOU, THANK YOU!!!

Now I am getting this error "Arithmetic overflow error converting numeric to data type numeric"

Both fields are defined as "money".

Thanks for the help...I am pulling my hair out, I thought...

Thanks for the quick reply. My question is that if I make the value 1, then the table (which will have almost 700k calculations) will be invalid. I cannot change...