Software (include version): Ancora, DocStar IDC, Epicor IDC    


Use Case: Vendors with ' not showing is list (example Smith's Trucking and Towing)


Customer: N/A


Prerequisites: 


Instructions:

  1. Add the ending to your where statement - shown in sample below

    1. SQLEXEC(STRJOIN("select [VendorID] from dbo.PIF_Vendor where [VendorName] ='",STRREPLACE(FT_VENDOR_ERP,"'","''"),"'"))


Helpful Links: N/A