title: Select or leave a field blank dependent on a condition without affecting query
body: <p>I would like to select a field but only under specific circumstance, otherwise i would like it to just be blank or null.  Example</p>
  
  <pre><code>Select
  a.Name,
  c.Hat as FancyHat,
  b.Shirt,
  b.Shoes,
  c.Hat
  
  from
  directory a, store b, superHatStore c
  
  where 
  a.key = b.key
  a.key = c.key
  </code></pre>
  
  <p>now I would only want to display a FancyHat name if it is a 'fancy_hat' example</p>
  
  <p><code>where 
  c.Type = 'fancy_hat'</code> </p>
  
  <p>but if I put it in the where clause it is too restrictive... because I also want the name of the hat to be in another field regardless of hat type... maybe I am just doing something wrong.  Any suggestions would be greatly appreciated, Thanks</p>