Undocumented Funtion: PWDCOMPARE() 1

[Creeder]

Has anyone you this function to compare 2 passwords? Somehow i am not getting it to work properly

eg: SELECT PWDCOMPARE('test','test') should return a 1 which is a success.

Anyone has experience using it? I am using SQL 2000 by the way. Thanks.

 

[tlbroadbent]

I've played with PWDCOMPARE and PWDENCRYPT but do not use them in any applications. They are subject to change and using them could result in broken applications when upgrading.

The correct syntax is pwdcompare('text',<encryptedtext>) as in the example below. pwdencrypt is used to encrypt the text string for the second pwdcompare parameter.

print pwdcompare('helloworld', pwdencrypt('helloworld')) Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.