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

Userlevel 4
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