Skip to main content
Question

How to write update query if column name contains special character? I have used below query but its throwing syntax error "Update [Zahlungsfreigabe_tracking$$] set [1.Erinnerung] ='X' where [P-Bereich] ='$strP-BereichNo$';"

  • July 8, 2022
  • 2 replies
  • 370 views
P
How to write update query if column name contains special character? I have used below query but its throwing syntax error "Update [Zahlungsfreigabe_tracking$$] set [1.Erinnerung] ='X' where [P-Bereich] ='$strP-BereichNo$';"

    2 replies

    Ashwin A.K
    Forum|alt.badge.img+10
    • Ashwin A.K
    • Navigator | Tier 3
    • July 8, 2022

    Hi @Poonam Pandire​ ,

     

    You have to edit the headers.

    Tell the business users that they have to provide headers, and that the only special character they can use is underscore(_).

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    P
    • Poonam 8147
    • Author
    • Cadet | Tier 2
    • July 12, 2022

    Thanks @Ashwin A.K​ 

    Terms & ConditionsCookie settingsAccessibility statement