Escaping SQL character to avoid "incorrect syntax near" error

[DiarmuidCorey]

Hi 

I am having difficulty getting BP to extract an item using SQL

"SELECT * FROM #Input WHERE [DisplayName] = '10. Folder - 'Triage' ' "

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!

[PabloSarabia]

Hello

Try using a double ', like that:

"SELECT * FROM #Input WHERE [DisplayName] = '10. Folder - ''Triage'' ' "



Bye 🙂