Allow Special Charactors(!@#$%^&*), Alphabets and Numerics

Jignesh Trivedi13y ago

hi,
you can make your Table 's column case sensitive by help of SQL Collation.
like

SELECT UserID, Password
FROM UserMaster
WHERE UserId COLLATE Latin1_General_CS_AS = 'MyUserId'

Please refer
http://msdn.microsoft.com/en-us/library/ms190920.aspx

http://msdn.microsoft.com/en-in/library/ms144250%28v=sql.105%29.aspx
hope this will help you.

manjula d13y ago

Sir How To set caseSensitive for username and password am using MySqlserver database Please Help me..

Vulpes13y ago

The following regular expression will validate a password which contains between 6 and 12 upper or lower case letters, numerals or special characters (!@#$%^&*):

string regExp = "^[a-zA-z0-9!@#$%^&*]{6,12}$";

manjula d13y ago

password should allow the Special Charecters, numerics and alphabets and also username and password should be case-sensitive how to possible to do any one know about these please help me................

Jignesh Trivedi13y ago

hi,
your question is not too much cleared.
you want to generate this type user id /password or you want to validate this?

Hemant Srivastava13y ago

Try validation using regular expression (regex in .Net)