Escape single quote

I’m trying to pass in a SQL statement from a DataGenerator to a DBInputTable component via the Query URL (port:$0.field1:discrete). The problem is that the DBInputTable seems to not be able to process a single quote in my query (SQL snippet below).

CONCAT(associates.firstname, ' ', associates.lastname)

Is there a way to escape the single quote? I’ve tried several things but nothing seems to work.

Hi,

I just tested a similar usage with no issues. In order to resolve your issue please provide me with the following.

1. Version of your Designer.
2. Version of your MS-SQL database.
3. Your graph file without any sensitive information.
4. Your console output when the error occurs. Just copy-paste it, please.

Thank you,

I sent the pertinent details to Jay Benedetti and Kevin Scott, as I was on a call with them regarding other matters.