title: How to select a column in SQL Server with a special character in the column name?
body: <p>I have a table contain the '%' in the column title, and this cause problem when I do the select statement on that column (Find below for more details). Does anyone know how can I select that column by not keeping the original column title? </p>
  
  <p>Example:</p>
  
  <pre><code>Table1
  name  ref_no  tot_sales  %Phone
  -------------------------------
  Alan  1       1          100%
  amy   2       1          50%
  ken   3       4          30%
  </code></pre>
  
  <p>Script:</p>
  
  <pre><code>Select %Phone From Table1
  </code></pre>
  
  <p>Error Message :</p>
  
  <blockquote>
    <p>Incorrect syntax near phone</p>
  </blockquote>