@jg80, I actually got it working. I was able to do it using CASE in the UPDATE statement. It came to me while I was looking at your code from earlier, so you were definitely helpful and I appreciate it.
1 Like
Ah! Of course...good ol' CASE...well done 