Kbase P144573: The SQL-92 REPLACE function does not replace null
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/04/2009 |
|
Status: Unverified
SYMPTOM(s):
The SQL-92 REPLACE function does not replace null
The record is displayed as is on the database
FACT(s) (Environment):
Trying to replace apostrophe (') with ''
If replace the apostrophe with blank (' '), it displays the blanks on the record display as expected
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
According to the SQL-92 guide, if any of the arguments of the expression evaluates to NULL, the result is NULL.
FIX:
In order to replace character(s) with null or '', use the solution P34638 as a workaround.