>Hi all, the other day I needed to do a SQL SELECT and I used count(distinct "Field_name") and that worked they way I wanted but realized that's a feature of the VFP SQL syntax that is undocumented (at least on the help files). Now my question is: are there any other undocumented feature/function/command like that? Where can I find information on them?
>
>Thanks in advance!

Enmanuel

COUNT and DISTINCT are documented under SELECT - SQL, although they are standard SQL commands, they are still included in the VFP documentation.

Kev