title: SQL Conditional column data return in a select statement
body: <p>Here is a simplication of the problem: I have a select that looks like this:</p>
  
  <pre><code>Select ID, Assignee, WorkStream from assignees;
  </code></pre>
  
  <p>And a snap shot of the data returned looked like this</p>
  
  <pre><code>1|Joe Soap|Internal
  
  2|Mrs Balls|External
  </code></pre>
  
  <p>What I would like to do is have the select not display the Assignee name if the worksteam is internal. Instead to display the Workstream. </p>
  
  <p>So for example the outcome I want to achieve would be this:</p>
  
  <pre><code>1|Internal|Internal
  
  2|Mrs Balls|External
  </code></pre>
  
  <p>I hope this makes sense? Basically a conditional select that can detect if a certain column contains a certain value, then replace another columns value with [whatever]. </p>
  
  <p>Thanks in advance!</p>
  
  <p>EDIT I want to achieve something like this:</p>
  
  <pre><code>Select ID, if (workstream='internal' select Workstream as Assignee - else - select Assignee as Assigneee), WorkStream from assignees;
  </code></pre>