Apostrophe and Execute SQL Statement

Jun 24, 2013 at 4:59 PM
I'm not able to get the Execute SQL command to work with fields that have apostrophes.

basic statement:
insert into tableX
([A],[B],[C])
Values
('[SPa]',REPLACE('[SPb]',''',''''),'[SPc]')

Workflow error:
Error on executing: Incorrect syntax near 's'.

Field value is: Bob's