title: Can I override a column's value in Select CASE SQL
body: <p>Can I override a value in a column such that if a case is true, it tells value x to be equal to another dynamic value in the query.  Here's pseudocode. I know this doesn't work.</p>
  
  <pre><code>Select jobTitle, managerTitle, bigBossTitle,
      CASE WHEN jobtitle like '%DEVELOP%' THEN managerTitle = bigBossTitle
      END 
  From PeopleTable
  inner join... other tables...
  </code></pre>
  
  <p>Thanks.</p>