"Statement contains an illegal usage of the NUMBER(*) function"
| Item |
Description |
|
SQLCode
|
-864L
|
|
Constant
|
INVALID_NUMBER
|
|
SQLState
|
42W71
|
|
ODBC 2 State
|
37000
|
|
ODBC 3 State
|
42000
|
|
Sybase Error Code
|
2514
|
|
Severity Code
|
15
|
Probable cause
The NUMBER and IDENTITY functions can only appear in the select list of the outer-most SELECT block. It cannot be used in any subquery or in a predicate.