UPDATE dbo._RefObjChar SET InventorySize = number inventory size WHERE id IN ( SELECT id FROM dbo._RefObjCommon WHERE CodeName128 LIKE '%Codename Pet%')