Update Data Using Join Operation in SQL Server

Question

I want to know how to update data using join operation in SQL server.

Thank you.

Answer 1

Well. You don't have any special char need in your spec.

Define a strings like:
"abcdefghijklmnopqrstuvwxyz0123456789".
"abcdefghijklmnopqrstuvwxyz"
" 0123456789"
Have a boolean flag for each.
Algo:
1) Iterate through each pwd char. Make sure the char falls in above string. When char not found, set the flag to false. When a char is lower case letter set the relevant flag to true. When a char is digit set flag related to digit as true. At the end of iteration you can check the flags to satisfy first three points.
2) For fourth point you need a inner loop that again iterates through all your chars. Here you can check the repeatable patterns.