title: how do I select a column based on condition?
body: <p>I have a variable called @status which I set before this select statement:</p>
  
  <pre><code>Select
  ordr_num as num,
  ordr_date as date,
  ordr_ship_with as shipwith
  From
  order
  where ordr_num = @ordrNum
  </code></pre>
  
  <p>I only want to select <code>ordr_ship_with</code> column if <code>@status &lt;&gt; 'Cancelled'</code>, otherwise I want to select null for shipwith.  How do I accomplish this?</p>