>>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
Hi Kevin, yes I know. What I meant is for example the help file says you can use "SELECT DISTINCT" but not that you can include the distinct clause inside any of the other functions used in the SELECT statement, like the COUNT() function in my case.
Enmanuel
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain