• Hi Luis
    This seems to work perfectly!  Thank you so much for the help. I didn't even consider a CASE statement...kept thinking about self joins, CTEs, etc.

    Thank you again
    . - will