• Oh, yeah. I've used case statements in computed columns before. That's actually part of the reason I was hoping there was a way to do it in default. But you're right. The fact that computed columns can't be updated is a problem in this case.

    Looks like I'm going to have to go with a trigger.

    Thanks everyone!