LISTING 1: Stored Procedure to Use SQL Server 6.5 Encrypted Strings with the SQL Server 7.0 Version of Pwcompare

CREATE PROCEDURE CompareSQL65EncryptedString (@SSN char(9), @Pin  char(4), @return int
output)
AS
IF EXISTS 
(
SELECT * FROM mytable (NOLOCK)
WHERE SSN = @ssn
AND pwdcompare(@pin,CONVERT(sysname,CONVERT(varbinary(30),CONVERT(varchar(30),pin))),1) =1
)
	SELECT @return = 1
ELSE
	SELECT @return = 0
GO