query to update Item code from threee digit to four digit 8-18-2022
update civ_Items set ItemCode = LEFT(ItemCode,len(ItemCode)-3) + '-0' + RIGHT(ItemCode,3) WHERE  NOT (ItemCode LIKE '%-%')