I tried that in the beggining and there seems to be almost as many variables as there are records so nothing seems to get things done correctly not to mention the time it takes so we just fix the obvious before they get to the SELECT and go on with life. It would be quite lovely if we could get it done to a science though...
Thanks in advance for your help! :-)
Randall L. Johnson