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-determinstic function, that alias cannot be referred to elsewhere in the query.