In this blog post, you’ll learn more about the Sybase Error Statement contains an illegal usage of the non-deterministic function ‘%1’ and the reason for receiving this error
Sybase SQL Error Message
Statement contains an illegal usage of the non-deterministic function ‘%1’
Reason for this Error
Non-deterministic functions cannot appear in a CHECK constraint, or any other type of integrity constraint. They may appear anywhere within a query, view, or derived table. However, if an aliased SELECT list expression contains a non-deterministic function, that alias cannot be referred to elsewhere in the query.
