Dynamic Input Tool - SQL Update WHERE Clause - adding extra quotes (?)

[KD_dell_ire]

Hi,

I was looking for help around solving an issue I had with "Dynamic Input" tool.

1. Was trying to use SQL: Update WHERE Clause
2. was trying to replace text like ('ABC00190205909') using a replacement field which has text  like ('ABC00190205909','DEF00190205909','XYZ00190205909')
3. However the Dynamic Input failed to run (No Columns Returned) due to it adding additional quote marks and those additional quote marks (''ABC00190205909'',''DEF00190205909'',''XYZ00190205909'')prevented the SQL from executing

Any ideas on this?

[BrandonB]

Can you strip the quotes from your original replacement text field? 

[KD_dell_ire]

I tried that @BrandonB but it then just had strings passed through like (ABC001,DEF002,GHE003) etc. and that will not run in the postgreSQL environment that I need it to run.