Kbase P28422: SQL-92 CONCAT() function does not support integers
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/07/2003 |
|
Status: Unverified
SYMPTOM(s):
SQL-92 CONCAT() function fails with integers
Inconsistent types (7481)
Syntax error (7587)
CAUSE:
The CONCAT() function supports only integers as documented in the Progress SQL-92 Guide and Reference.
FIX:
First convert the arguments to character before using CONCAT()