How to apply SQL criteria with value containing a single quote?
Article ID: KB0074097
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.0 and higher |
Description
This article shows how to escape a single quote in SQL scripts.
Issue/Introduction
How to apply SQL criteria with value containing a single quote?
Environment
Windows
Resolution
Add two single quotes instead of one in the scripts . For instance, to select rows with "Name" containing single quotes in the below spreadsheet1,
the following scripts can be applied in the Statistica Query Builder:
Feedback
Yes
No
Powered by
