Wayne I believe you are 100% correct. You statement works perfect after I realized what the REAL statement was..

Thank again!

Tom

Thank you all for taking so much of your time to help.

Jeff, I did figure out the code this morning - but I did type the code exactly...

Wayne,

I tried what you sent me and ran into just a small problem... but I think I fixed it...

Here's what you sent: WHERE DateEnd >= '1/1/2009' and...

Outstanding,

Thank you so much for the help. I'll give it a try here in a few..

Tom

All very good suggestions...

Thank you.

Thank you,

I'll give the procedure a try in a few and let you know how it worked.

Thanks for your suggestions...

Tom

Thank you for the reply,

I am integrating SQL with Visual Web Developer so the interface is being written in ASPX or asp.net.

I was hoping there was a...

Thank you,

That seems to simplify my process quite a bit.

I'll give that a run on my tables and see what happens!

Tom

Interesting...

Not concerned about an extra row as long as it's blank or could be used as a separator between name groups..

Could you provide an example of how...