Firstly my apologies for not responding sooner

Secondly, thank you all for the marvellous responses and ensuing competition.  Sadly I must now say my original SQL was a very poor contender over 1,000,000 records, and some of the alternatives, well let's just say WOW!

I have really learned some stuff from you people, so much appreciated.

Stephen