Código SQL [-] BEGIN IF (NEW.ESTADOCIVIL IS NULL ) THEN NEW.ESTADOCIVIL='SOLTERO'; IF (NEW.ESTADOCIVIL='S') THEN NEW.ESTADOCIVIL='SOLTERO'; IF (NEW.ESTADOCIVIL='C') THEN NEW.ESTADOCIVIL='CASADO'; IF (NEW.ESTADOCIVIL='U') THEN NEW.ESTADOCIVIL='UNION LIBRE'; END
BEGIN IF (NEW.ESTADOCIVIL IS NULL ) THEN NEW.ESTADOCIVIL='SOLTERO'; IF (NEW.ESTADOCIVIL='S') THEN NEW.ESTADOCIVIL='SOLTERO'; IF (NEW.ESTADOCIVIL='C') THEN NEW.ESTADOCIVIL='CASADO'; IF (NEW.ESTADOCIVIL='U') THEN NEW.ESTADOCIVIL='UNION LIBRE'; END