Wow! That was simple. I've used the DISTINCT keyword but didn't even cross my mind. I knew I was overlooking something obvious like this. Well, at least for me, I though the differences between VFP and MSSQL was interesting.
Thanks!
>John
>
>SQL Server does allow the "distinct" keyword which will solve the issue.
>
>There are quite a few differences between SQL server and VFP regarding Group, some of which make no real sense to me... but that is a different issue.
>
>Regards
>
>JR
It's "my" world. You're just living in it.