title: if statement in SQL computed Column Specification
body: <p>I'm trying to built in if statement in computed column
  What I'm trying to accomplish should look like this but this is more pseudo code:
  SalePrice-Cost-(if(isConsigned=1 Then Payout else 0))</p>
  
  <p>How do I this and can I use if statement inside computed column or it should be something else?</p>