title: How do you get the product of two case statements
body: <p>I am trying to combine case statements using the following code and keep encountering errors.</p>
  
  <pre><code>SELECT     
          dbo.COL_TBL_WAGES.[Job Group], 
          SUM(CASE
                   WHEN COL_V_COST.EMP_TNG_RL_CD = 'ST' 
                    THEN ([CountOfEMP_TNG_STT_DT] * 
                        (WHEN IsNumeric([TBL_VCOURSE.Length]) 
                          THEN TBL_VCOURSE ELSE 0 END) AS ST_Hours
  </code></pre>