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$';"


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+8
  • Navigator | Tier 3
  • 2445 replies
  • 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


  • Author
  • Cadet | Tier 2
  • 9 replies
  • July 12, 2022

Thanks @Ashwin A.K​ 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings