Thank you for your advice. For my needs this appears to be a great solution.

Thank you. I ran a test. It's amazing. It simplifies what I was planning to do.

I am wondering if there are any negatives beyond the negative of hardcoding a value...

Thanks to both of you for getting back to me.

I am a little confused about the unique filtered index. I was trying to read up on them, but every article...

Thank you both for getting back to me.

I am glad that my explanation wasn't as confusing as the way the customer explained things to me.

Phil's response is very much in...