That was it. I knew I was doing something stupid... :-)

Thanks,
Paul

>>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