It will if your "where" will look like this:

where DECRYPT_TEST(empid, 'zzzzzzzz') in (1234, 5643, 3445)