I need an SQL query that selects from either Column A or B depending on the existence of a string in Column C
<p>I need an SQL query that selects from Column A if Column C contains the string 'ebook'. Otherwise, select from Column B.</p>

<p>So something like:</p>

<pre><code> IF (Table.ColumnC = "ebook") SELECT Table.ColumnA AS Publisher
ELSE SELECT Table.ColumnB AS Publisher
</code></pre>