To specify that a new password must be different from the old one:
SELECT '' violated FROM PWDCREDENTIALS WHERE OLDPASSWORD = NEWPASSWORD