>Hello,
>
>In a VFP table, I would like to have an histogram of a field. (To know how the field is populated).
>This field can be Numeric or Character.
>
>For example, output will be :
>
>In field NB_TEST :
> string "ABCDEF" : 10000 occurences (present in 10000 records)
> "TEST1" : 5600 occur
> "TESTxx" : 150 occur
>
>Is it possible to have such a thing with a SQL request ?
>Or if it's not, how can I get this ??
>
>Thanks a lot !
>Regards
>Steph

something like..

select NB_Test, count(*) from MyTable group by NB_Test