title: SELECT not null column from two columns
body: <p>I have a table that has two columns, one of which will be <code>NULL</code> and one will not, what I would like to do is something like:</p>
  
  <pre><code>SELECT (column1 OR column2) AS value
  </code></pre>
  
  <p>But I need to retrieve the value that is not null. I feel like this is probably an easy question, but any help is appreciated.</p>