username and password
-
how to insert username and password in table(sql server 2005) with case sensitive. so I can check small(abc...) and capital(ABC...) letters also while logged in. thanks
You get the best out of others when you give the best of yourself.
-
how to insert username and password in table(sql server 2005) with case sensitive. so I can check small(abc...) and capital(ABC...) letters also while logged in. thanks
You get the best out of others when you give the best of yourself.
Hi, Just use UPPER & LOWER method during insert command in sql...
-
Hi, Just use UPPER & LOWER method during insert command in sql...
that is fine but it will be static in either small or block letters. I want in, whatever user enter in small or block letter. should not be changed internally. thanks to give me response.
You get the best out of others when you give the best of yourself.
-
how to insert username and password in table(sql server 2005) with case sensitive. so I can check small(abc...) and capital(ABC...) letters also while logged in. thanks
You get the best out of others when you give the best of yourself.
-
Just insert teh values as suppplied, then when you are looking for them use
select * from table where convert(varbinary,username) = convert(varbinary,@inputvalue)Using varbinary effectively makes the select case sensitiveBob Ashfield Consultants Ltd
thanks a lot for your kind help. it's also working fine....... thanks
You get the best out of others when you give the best of yourself.
-
how to insert username and password in table(sql server 2005) with case sensitive. so I can check small(abc...) and capital(ABC...) letters also while logged in. thanks
You get the best out of others when you give the best of yourself.
Change collation to something case sensitive if you want to have case sensitivity.
--------------------------- Blogging about SQL, Technology and many other things