Kbase P5892: How to insert literals with single quotes into a Progress SQL-92 column?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to insert literals with single quotes into a Progress SQL-92 column?
FACT(s) (Environment):
Progress 9.x
FIX:
According to the SQL-92 standard, literals with single quotes can be used like:
UPDATE pub.company SET name = 'Peter''s Company'
WHERE companyid = 1;
Another way of doing this is through the CHR Progress SQL-92 function, which is a Progress extension and not a standard. e.g.:
UPDATE pub.company SET name = 'Peter' + CHR(39) + 's Company'
WHERE companyid = 1;