Glad my post could help. I was surprised to see activity on this post a year later

Thanks...I try to stay away from cursors, but I like the select statement you did.

Thanks Vasc, but I just finished using the example that Journeyman gave me and it did exactly what I needed.

Thanks to all of you for your help...now that I...

I tried what you said and I'm getting 3 errors (all the same) "line 1: The column prefix 't1' does not match with a table name or alias name used in the...

Current output:

I guess I also have to remember to hit enter to make my sentences wrap

Actually, I figured out what I was doing wrong. Ray, thanks for your response of specifying the value of WO1. That clued me into what I was doing wrong. I...

I spoke too soon. It is not giving me the exact results I want. Can you look at it and see if I have the syntax correct that you intended? Thank you.

Select...

Thanks. That worked great. Sorry about the post. I pasted in the question and I did not know that it would not wrap.