- Remove all ASCII numbers and ASCII special characters from the beginning and end of the password string.
- Use the resulting string (the stripped password) in the query:
SELECT*FROM DBC.PasswordRestrictions WHERE UPPER(RestrictWords)=UPPER(‘StrippedPassword’)