check capital letters function in sql server 2000

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 2000 Forums

Transact-SQL (2000)

check capital letters function in sql server 2000

Author

Topic

asad
Starting Member

16 Posts

Posted - 2006-08-22 : 06:57:47

i have a problem... when i save password in sql 2000 table with lower case it will save correctly. when user press login name and password with capital letters then sql query select statement selects the required record and user will log in.

asad

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-22 : 06:59:43

SELECT * FROM MYPASSWORDTABLE WHERE CONVERT(VARBINARY, MYPASSWORDCOLUMN) = CONVERT(VARBINARY, @UserPassword)

Peter Larsson
Helsingborg, Sweden

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-08-22 : 07:01:44

check out this link

http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

Chirag

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-22 : 07:17:18

Avoid BINARY_CHECKSUM if possible.

With BINARY_CHECKSUM, 'aa' equals 'bQ' and there are many more cases where dupes are found.

Peter Larsson
Helsingborg, Sweden

asad
Starting Member

16 Posts

Posted - 2006-08-23 : 01:26:53

thnx for all of u

asad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources