title: SQLite - Using a hyphen in a column alias
body: <p><strong>EDIT</strong>: Have been using SQLiteBrowser as an IDE\Tool</p>
  
  <p>Not a frequent user of SQLite - please forgive my ignorance.
  The query below is part of a bigger query;</p>
  
  <pre><code>SELECT DISTINCT T1.Material AS "Diameter", 
                  T2.sLength  AS "0-110mm", 
                  T3.sLength  AS "110-160mm", 
                  T4.sLength  AS "225-300mm", 
                  T5.sLength  AS "300-450mm", 
                  T6.sLength  AS "450-600mm", 
                  T7.sLength  AS "600mm-" 
  FROM   "mycte" T1 
         LEFT JOIN "mycte" T2 
                ON T1.Material = T2.Material 
                   AND T2.Diameter = "0-110mm" 
         LEFT JOIN "mycte" T3 
                ON T1.Material = T3.Material 
                   AND T3.Diameter = "110-160mm" 
         LEFT JOIN "mycte" T4 
                ON T1.Material = T4.Material 
                   AND T4.Diameter = "225-300mm" 
         LEFT JOIN "mycte" T5 
                ON T1.Material = T5.Material 
                   AND T5.Diameter = "300-450mm" 
         LEFT JOIN "mycte" T6 
                ON T1.Material = T6.Material 
                   AND T6.Diameter = "450-600mm" 
         LEFT JOIN "mycte" T7 
                ON T1.Material = T7.Material 
                   AND T7.Diameter = "600mm-" 
  WHERE  T1.Material &lt;&gt; ''
  </code></pre>
  
  <p>And while I use an alias with a single hyphen\minus in the alias, the fields return empty.
  If I rename the alias "0-110mm" to "0--110mm", the column's fields return data.
  It would seem as if a single hyphen\minus is messing things up.</p>
  
  <p>Any ideas?
  Thanks in advance.</p>