title: Select a column if other column is null
body: <p>I need to select a field called ProgramID from a table and if the ProgramID is NULL then I need to select the value in the InterimProgramID from the same table and alias it as ProgramID.</p>
  
  <p>How can I make a conditional SELECT statement to do this?</p>