I added TRY/CATCHES around the query, but 0 records were added. I have 17,000+ records in the originating table, and 533 in the resulting table.

So here's my question...

SELECT

RIGHT('000000' + convert(varchar(6), PartNo), 6),

0,

...

NOW IT WORKS.

Thank you...

Dan's posted code produces:

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near '0'.

Produces Incorrect Syntax near 0. This is bit data - perhaps I need to use true / false??

INSERT INTO dbo.Purchasing(PartNumber, IsHardware, KitAlways, ChinaPN, KitChina, InstallTime, LaborClass, UnitCost)

SELECT

RIGHT('000000' +...

I'm just trying to update another table based on various criteria, obviously. What you are saying is that there must be better ways for me to do this??

Thanks. One more thought, is there a way to update the same field in another table with the same statement?

Any recommended reading?