Kbase P121102: Syntax error with SELECT * FROM PUB.customer WHERE '0' IS NULL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/01/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.1x
SYMPTOM(s):
Syntax error in SELECT * FROM PUB.customer WHERE '0' IS NULL
Using SQL92 clients
Connecting via ODBC and/or JDBC
FIX:
Use IFNULL function.
Example: SELECT * FROM PUB.customer WHERE IFNULL( '0', 1 ) = 1