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

  • 8 July 2022
  • 2 replies
  • 11 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

Userlevel 3
Badge +7

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

Thanks @Ashwin A.K​ 

Reply