>update product set Name = 'RocheThomas RT14 Valve Oil', set ProductTypeID = 8 where SKU = 'AE1001'Paul,
I'm pretty sure the issue is that you don't need the second "set" in your statement (just before ProductTypeID).
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer