Thank you Lynn for your response.
I have been offline for a few days and have not been able to try your solution.
What I had been trying was using a series of case statements checking for each condition and that was working about as well as tits on a bore hog, hence my post.
Yes, this is on SQL 2000, but since you suggested CTEs maybe I can use your suggestion as a guide to put something together in SQL 2000.
Thanks Again.
Gary