I have a dropdown populated by a webservice, the webservice returns an array of string and one of the strings has a single quote and I get this error in infopath
The query cannot be run for the following DataObject: QueryOppsFormByName
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:
Server was unable to process request. ---> Unclosed quotation mark before the character string ''.
Line 1: Incorrect syntax near 'Fund'.
I can replace the single quote in the webservice but I need it in the drop down because it's suppose to be displayed the exactly, any idea's?