title: Removing [] around column in SQL Server 2005
body: <p>when I was renaming the column in SQL Server, I accidentally inserted the square brackets around the column. The actual statement that I used was:</p>
  
  <pre><code>SP_RENAME 'customer.[EMPLOYEENAMES]', '[EMPLOYEENAME]', 'COLUMN'
  </code></pre>
  
  <p>But when I try to retrieve the data it just says and I even tried with out square brackets, it gives the same error</p>
  
  <blockquote>
    <p>Invalid column name '[EMPLOYEENAME]'.</p>
  </blockquote>
  
  <p>How should I remove the square brackets.</p>