To specify that the length of a password must be greater than 6 characters:
SELECT '' violated FROM PWDCREDENTIALS WHERE length(NEWPASSWORD) < 6