Skip to main content
P
Poonam 8147
Cadet | Tier 2
July 8, 2022
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
  • 406 views
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
    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 8147Author
    Cadet | Tier 2
    July 12, 2022

    Thanks @Ashwin A.K​ 

    Terms & ConditionsAccessibility statement