>>Thank you in advance.
>
>No way:( You can't create SQL that would work unchanged for VFP and SQL all the time. You are wasting your time trying to make it compatible IMHO. Write them depending on backend.
>Cetin

If both fields are of character type, you can just group by each field individually. Otherwise I agree, we need back-end specific query.