>>>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

Right, I gotcha now, I'm not sure whether it would be necessary, I mean I think most people would always attempt wrapping commands around other commands anyway.

Saying that though, the documentation on the VFP SQL elements is poor IMO, it's not detailed enough and it is more powerful than the documentation leads you to believe.

Kev