title: Selecting Values based on value
body: <p>I have a table with 6 Columns with int values AreaID is the Forigen Key.</p>
  
  <pre><code>    B1 H1 F1 A1 U1 AreaID
      0  3  -1 40 -1 120
      34 7  -1 3  -1 120
  </code></pre>
  
  <p>What I need to be able to do is get a select statement that will return a Distinct list
  of the above columns WHERE AreaID = 120
  but discount any cols with a value of -1</p>
  
  <p>So the above example would return ideally the columns:
  B1,
  H1,
  A1,</p>
  
  <p>Can anybody help me with this?</p>
  
  <p>Many Thanks</p>
  
  <p>Jason</p>