Escaping SQL character to avoid "incorrect syntax near" error
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-04-21 06:43 PM
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!
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!
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
28-04-21 07:25 PM
Hello
Try using a double ', like that:
"SELECT * FROM #Input WHERE [DisplayName] = '10. Folder - ''Triage'' ' "
Bye 🙂
Try using a double ', like that:
"SELECT * FROM #Input WHERE [DisplayName] = '10. Folder - ''Triage'' ' "
Bye 🙂
