Link to home
Start Free TrialLog in
Avatar of bibi92
bibi92Flag for France

asked on

pwdcompare for doing case insensitive comparaison

Hello,


I search to use pwdcompare for doing case insensitive comparaison : 

SELECT  [name],

   [password_hash],

   GETDATE() as CollectDate

FROM [master].[sys].[sql_logins] WHERE PWDCOMPARE(lower(name),password_hash)=1 

Thank you 

regards 

Avatar of ste5an
ste5an
Flag of Germany image

A hash uses the given diction (including lower or upper case). There is no known method to find all hashes for different dictions of the same word besides using a dictionary.
Avatar of bibi92

ASKER

Hello 


Thank you so no solution to find this example of hashe Test = tesT


Regards 

Besides a dictionary? No, it should be obvious. A hash function is a one-way function. Otherwise, it would not be useful for cryptography.
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial