>>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
It is ANSI SQL and you can use it as is except that there is no CONVERT function in VFP, but we have CAST function. So, you can even use it as is by replacing CONVERT with CAST and adding GROUP BY.
However, using DTOS is simpler.
In SQL Server, it's also simple to use CONVERT with the specific code rather than this complex code you have.
If it's not broken, fix it until it is.
My Blog