>Just making sure I'm not missing this, but from the BOL it doesn't appear that there is an otherwise clause statement when doing a case, is that correct? If so, anybody have a "work around"? Thanks
>
>Kirk

ELSE is the otherwise

CASE when ... then ... when ... then ... ELSE... end