Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Password validation

Author  Topic 

ranganath
Posting Yak Master

209 Posts

Posted - 2007-11-16 : 00:02:37
Hi,

plz solve the following Password validation

Passwords must have at least six characters, and must contain at least one of each of the following types of characters: lowercase letters, uppercase letters, numbers or special characters

i.e password should contain
1 special character + 1 uppercase leter +1 lower case leter + 1 digit And length should be > 6

Space is not allowed.

georgev
Posting Yak Master

122 Posts

Posted - 2007-11-16 : 07:47:36
What have you tried so far?
I'm not sure what the forum etiquette is here when it comes to homework assignments, but as a general rule - if you're not willing to try then neither am I ;)


George
<3Engaged!
Go to Top of Page

hitman
Starting Member

23 Posts

Posted - 2007-11-16 : 08:03:24
just write your own CLR function for this

-----------------------
http://www.sqltips.info
-----------------------
Go to Top of Page
   

- Advertisement -