https://community.blueprism.com/t5/Product-Forum/Escaping-SQL-character-to-avoid-quot-incorrect-syntax-near-quot/m-p/102187#M48984 Hi&nbsp;<BR /><BR />I am having difficulty getting BP to extract an item using SQL<BR /><BR />"SELECT * FROM #Input WHERE [DisplayName] = '10. Folder - 'Triage' ' "<BR /><BR />the folder 'Triage' has a single ' at the end of the word, I believe this is causing the issue but I cannot escape it successfully, any ideas would be great! Wed, 28 Apr 2021 17:43:42 GMT DiarmuidCorey 2021-04-28T17:43:42Z https://community.blueprism.com/t5/Product-Forum/Escaping-SQL-character-to-avoid-quot-incorrect-syntax-near-quot/m-p/102187#M48984 Hi&nbsp;<BR /><BR />I am having difficulty getting BP to extract an item using SQL<BR /><BR />"SELECT * FROM #Input WHERE [DisplayName] = '10. Folder - 'Triage' ' "<BR /><BR />the folder 'Triage' has a single ' at the end of the word, I believe this is causing the issue but I cannot escape it successfully, any ideas would be great! Wed, 28 Apr 2021 17:43:42 GMT https://community.blueprism.com/t5/Product-Forum/Escaping-SQL-character-to-avoid-quot-incorrect-syntax-near-quot/m-p/102187#M48984 DiarmuidCorey 2021-04-28T17:43:42Z https://community.blueprism.com/t5/Product-Forum/Escaping-SQL-character-to-avoid-quot-incorrect-syntax-near-quot/m-p/102188#M48985 Hello<BR /><BR />Try using a double ', like that:<BR /><BR /><SPAN>"SELECT * FROM #Input WHERE [DisplayName] = '10. Folder - ''Triage'' ' "<BR /><BR /></SPAN><BR /><BR />Bye <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Wed, 28 Apr 2021 18:25:31 GMT https://community.blueprism.com/t5/Product-Forum/Escaping-SQL-character-to-avoid-quot-incorrect-syntax-near-quot/m-p/102188#M48985 PabloSarabia 2021-04-28T18:25:31Z