question

BlazingBishop avatar image
BlazingBishop asked

Hi how can i check if the password field in the table contains certain Characters?

Hi guys

How can i check to see if a password field in a table on registration of a user, the system has to check that the password entered has

  • At least 8 characters
  • A wild character
  • An uppercase character.

If the password requirements are not satisfied, a message should be display to request the user to re-enter the personal details with the correct password format.

sql server 2012password
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·

At the database level? I sincerely hope you can't, as the password is encrypted. Do it at the front end. Much better user experience.

If you're storing your passwords in plaintext, then you have bigger problems to solve.

1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.