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$';"
Userlevel 4
+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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.