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