UPDATE Item SET
[Description] = I.ItemDesc
FROM (SELECT [ID], UPPER([Description]) AS ItemDesc FROM Item) AS I WHERE Item.[ID] = I.[ID]