title: Can the SQL Case Statement fall through?
body: <p>Is there a way to make a CASE statement in SQL fall through like the case statement in C#?  What I don't want to do is the example below but if that’s my only option I guess I'll go with it.</p>
  
  <p>EXAMPLE:</p>
  
  <pre><code>@NewValue =
     CASE
        WHEN @MyValue = '1' THEN CAST(@MyValue AS int)
        WHEN @MyValue = '2' THEN CAST(@MyValue AS int)
        ELSE NULL
     END
  </code></pre>
  
  <p>EDIT:</p>
  
  <p>I'm using SQL Server.</p>