ALTER TABLE IES.T_EHR_TNM_TOPOGR_MAP ALTER COLUMN TNM_7  type bool USING CASE WHEN TNM_7=0 THEN FALSE ELSE TRUE END;

ALTER TABLE IES.T_EHR_TNM_TOPOGR_MAP ALTER COLUMN TNM_8  type bool USING CASE WHEN TNM_8=0 THEN FALSE ELSE TRUE END;