Im trying to update query a Long string in a single cell but getting syntax error eventhough removed special characters and whitespaces
Example :
UPDATE DPOs$$] set Count] = $SampleString$, nAttachment Name] ='$UpdateAttachmentName$', ePO Download Status]='$Status.LegacyAutomation:listToString$' where hPO]=$PO_Number$;
In '$UpdateAttachmentName$' the values is :Vendor_Order_form_Freshworks_SaaSMQL_042324_East_West_Coast-PO-13087 , Vendor_Order_form_Freshworks_SaaSMQL_042324_Mf_Edu-PO-13087 , PR___17487_Vendor_Order_form_Freshworks_SaaSMQL_042324_East_West_Coast_1docx-PO-13087 , PR___17487_Vendor_Order_form_Freshworks_SaaSMQL_042324_Mf_Edu_1docx-PO-13087
If i remove one Name in the variable its updating but if i add extra its throwing syntax error