locked
How to handle spaces in column names RRS feed

  • Question

  • Hello. How do I handle spaces in column names when using select? 

    COUNT("IV Falcon Invoice Num") 
    FROM dbo.Invoices

    Monday, October 17, 2016 11:36 PM

Answers

  • Hi <gs class="GINGER_SOFTWARE_mark" ginger_software_uiphraseguid="567626c9-4854-463c-b030-0a63002c3f6c" id="082ca25c-7f6c-4882-8622-04c254007960">ALex</gs>,

    Wrap the names in square brackets.


    Please click Mark As Answer if my post helped.


    • Proposed as answer by Darren GosbellMVP Tuesday, October 18, 2016 12:30 AM
    • Marked as answer by AlexMartini Tuesday, October 18, 2016 12:32 AM
    • Edited by AV111Editor Tuesday, October 18, 2016 12:33 AM examp
    Tuesday, October 18, 2016 12:24 AM
    Answerer