>update product set Name = 'RocheThomas RT14 Valve Oil', set ProductTypeID = 8 where SKU = 'AE1001'
>
>I get the following error:
>Incorrect syntax near the keyword 'set'.
>
>Thanks,
>Paul
Try
update product set Name = 'RocheThomas RT14 Valve Oil', ProductTypeID = 8 where SKU = 'AE1001'
I took out the second word "Set".
Greg Reichert