I want to run a query that will append the Item.SubDescription1 field to the Item.Description.
Something like this: UPDATE Item SET Description = Description + ", " + SubDescription1
Is this possible? What would be the proper syntax?
Thank you, Tom