select cho_id, cho_zipCode from tbl_CHO_Operators where cho_segmentId = 2 and len( cho_zipcode ) = 4 update tbl_CHO_Operators set cho_zipcode = where cho_id =