In this blog post, you’ll learn more about the Sybase Error Statement contains an illegal usage of the NUMBER(*) function and the reason for receiving this error
Sybase SQL Error Message
Statement contains an illegal usage of the NUMBER(*) function
Reason for this Error
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.