> You can use 'union' statement in select statment.

Thanks, but the problem is that I can't control the order of the rows
returned this way. I believe, however, that Helen may have already answered
this in a previous post by using the SUSPEND in the SP in a way that I
wasn't aware I could do it.

I'll try it this week and see how I go.

Regards,
Myles

===============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Phone (480) 451-7440
www.techsol.org