Thank you all, that worked! I thought the SET required a subquery as that is how the examples were formatted that I found online. This is much simpler...

Hi Lowell. The question has been updated. It posted before I finished editing.

Thanks,

-Gary