Today, we’ll be checking one new area where we can implement regular expression to achieve the password validation without involving any kind of Macro, Stored-Proc.
Let’s consider the following conditions to be implemented –
1. Password should contain characters between 6 & 10.
2. One character should be digit.
3. One character should be in upper case letter.
4. There should be at least one special character.
Let’s check the Query & Output –
Similarly, you can add condition of lower case character if you want to make it more complex.
Hope, this will give you another way – to implement the same logic. 🙂