By no means did anything you say offend me. I apologize if that is how it was received.

I am glad you were able to get what you needed and I...

I understand that the insert would absolutely work as written. My concern was that it wouldn't go into the correct KitID. Sorry if my comments offended you...

A where clause is used to filter which records are returned from a query. An insert statement cannot have a where clause, it doesn't make sense. You are inserting the...

Once you post the ddl and such I am confident we can help you solve the issue you are facing. :-D[/quote]

Thanks. I appreciate that. Give me a bit. ...

Insert was actually the first thing I tried. This is my insert statement using the actual table and column names:

insert into Component (CmpnentID) values (8001090000) where KitID = '2560150001'

The...

Sorry for the confusion. I'm obviously not an expert.

The searching I've done for doing what I need suggests using an update statement to add information to an...

The result I want actually has one more line added to it. I need 7 unique records (for example) instead of the original 6.