Ninja's_RGR'us (8/2/2011)
srferson-957148 (8/2/2011)
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!
Why would you want the computed column to be updated?? That kind of defeat the purpose!
Remy,
I think the OP originally wanted to use the same kind of syntax for a DEFAULT and the column could be updated later.
I was just pointing out that CASE statements like that could be used for computed columns, which is not what the OP was originally requesting help on.
Todd Fifield