Paste code

CASE WHEN gestion_tipo IS NOT NULL AND gestion_tipo NOT LIKE &#039;&#039; THEN 1 ELSE 0 END FLG_GESTION_VPCONNECT,
         CASE WHEN gestion_tipo IS NOT NULL AND gestion_tipo NOT LIKE &#039;&#039; AND gestion_tipo NOT LIKE &#039;%Sin Contacto%&#039; THEN 1 ELSE 0 END FLG_CE_VPCONNECT,
         CASE WHEN gestion_tipo LIKE &#039;%Acepta%&#039; AND gestion_tipo NOT LIKE &#039;%No%&#039; AND gestion_tipo NOT LIKE &#039;%Visita%&#039; THEN 1 ELSE 0 END FLG_ACEPTA_VPCONNECT,
         CASE WHEN gestion_tipo LIKE &#039;%Acepta%&#039; AND gestion_tipo LIKE &#039;%No%&#039; THEN 1 ELSE 0 END FLG_NO_ACEPTA_VPCONNECT,
         CASE WHEN gestion_tipo LIKE &#039;%Lo Pensa%&#039; THEN 1 ELSE 0 END FLG_LO_PENSARA_VPCONNECT    ,
         CASE WHEN gestion_tipo = &#039;No Califica&#039; THEN 1 ELSE 0 END FLG_NO_CALIFICA_VPCONNECT,
         CASE WHEN gestion_tipo LIKE &#039;%Desisti%&#039; THEN 1 ELSE 0 END FLG_DEISTE_VPCONNECT,