Encryption without component

Ah yes, easier than i thought

Run against Northwind DB

DECLARE @Address nvarchar(60), @EncryptAddress nvarchar(60)

SET @Address = '123 Main Street'
SET @EncryptAddress = PWDENCRYPT(@Address)

INSERT INTO Employees (LastName, FirstName, Address)
  VALUES ('Doe', 'John', @EncryptAddress)
SELECT TOP 1 EmployeeID, LastName, FirstName, Address, Len(Address) As AddressLength
  FROM Employees ORDER BY EmployeeID DESC

SELECT EmployeeID FROM Employees
 WHERE LastName = 'Doe' AND Address = @Address
SELECT EmployeeID FROM Employees
 WHERE LastName = 'Doe' AND Address = PWDENCRYPT(@Address)

The first SELECT shows that you can't "see" whats in the "Address" column and the Length column just shows that something is in there

Now notice that the second SELECT brings back no results since the plain address didnt match the encrypted column "address", but the third one did

its a SQL 2000 function, access has nothing like this that i know of

(you did say above "SQL")

Z I am using this encryption for some time now and yes there was a little hole which supposedly has been plugged in sp3.
I use that script to authenticate a password:
strSQL =          "Declare @LoginUser varchar(30) "
strSQL = strSQL & "Declare @EncryptedPIN varbinary(255) "
strSQL = strSQL & "Select @LoginUser = (Select Username from Logins where Username = '" & Username & "') "
strSQL = strSQL & "Select @EncryptedPIN = (Select [Password] from Logins where Username = @LoginUser) "
strSQL = strSQL & "Select @LoginUser AS Username, Access, pwdCompare('" & Password & "', @EncryptedPin, 0) AS Success "
strSQL = strSQL & "FROM Logins where Username = @LoginUser"
Set RS = conn.Execute(strSQL)

this just returns either 1 for success or 0 in which case i throw him back

and the following to  encrypt an entered password:
pwdencrypt('" & Password & "')   within an insert that is. The field itself i use binary so even there is harder to read out. Works well for me and runs faster then most hash1's I found.

Hi, before I just found out that I wouldn't have access to SQL. Is it possible to use your function with an access database?

Thanks, Martin.