UPDATE z 
	SET Zone= RIGHT(zone, LEN(zone)- CHARINDEX('-',zone))
FROM tbzone z WITH (NOLOCK) WHERE ZoneTypeId = 46 