>Hi Folks, Thanks for all your replies.
>I thought I would keep it simple by showing a sample where there were
> just two fields... in reality there are more than the two fields.
>I note that there is a different solution if there are more than 2 fields !!!
>I'll take that into account.
>
>Thanks again
>Regartds.
>Gerard
>
In VFP I know only 3 solutions for this problem (and in SQL Server 2000).
In SQL Server 2005 and up I know 5 solutions.
If it's not broken, fix it until it is.
My Blog