>
>SELECT CTOD(SUBSTR(STR(fechlo,8,0),7,2)+"/"+SUBSTR(STR(fechlo,8,0),5,2)+"/"+SUBSTR(STR(fechlo,8,0),1,4)) AS fecha,;
> iif(alltr(proglo)#"BODPJIDH","Pers. Natural","Pers. Juridica") AS tipo,;
> "Hist. Conexiones" AS indicador,;
> COUNT(Conexiones_historico.fechlo) AS transxdia;
> FROM "datos!conexiones historico" Conexiones_historico;
> GROUP BY Conexiones_historico.fechlo, Conexiones_historico.proglo;
> INTO TABLE dbfstmp\conhist.dbf


Add a space to the string "Pers. Natural " - this will give you the desired results. What's happening is the first record of the result is always evaluating to "Pers. Natural" for the tipo field, and VFP is making the size of the field based on that. Since the other string is one character longer, it is being truncated.