>You need to group by some field and also CHAR and CONVERT are SQL Server functions. Although it's easy enough to find VFP replacements.
>
>Can you explain what do you want to achieve?
If it would have been ANSI SQL, I would have been able to get rid of supported code I need to keep in place for a VFP backend. So, it will remain as is. Thanks for the reply