Survey123 Pulldata SQL Where clause not working with special characters

[RobynSnookCCB]

I'm attempting to use the pulldata function in survey123 connect to get road information, I need to get the street name and use that in a future sql clause. I'm having the issue that street names with an apostrophe break the sql clause, it works fine with street names without any special characters.

This the statement:

pulldata("@layer","getValue","attributes.Total",${RoadQu}, concat("DISPLAYNAM='", ${RdName},"'"))

I've also tried this to no avail. 

pulldata("@layer","getValue","attributes.Total",${RoadQu}, concat('DISPLAYNAM="', ${RdName},'"'))

thanks