Extracting Int Value &&>= 0 From Output From HashBytes

Hi,

In my application I would like to retrieve hashed data from a DB on SQL Server 2005. I.e. for each record in a table I want to create a hashed value and return it to my application. The range of integer values is the positive range for T-SQL INT type, 0 through 2^31 - 1.

I've tried queries like the following, using the Northwind sample DB table Employees (http://www.microsoft.com/downloads/details.aspx?familyid=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en)




Code Snippet
SELECT FirstName, LastName,
CAST(CAST(HashBytes('MD5', FirstName + LastName) AS VARBINARY(4)) AS BIGINT) AS RecordID
FROM Employees





or




Code Snippet
SELECT FirstName, LastName,
CAST(CAST(HashBytes('MD5', FirstName + LastName) AS VARBINARY(4)) AS INT) AS RecordID
FROM Employees




The former returns data in the range 0 through 2^32 while the latter also returns negative numbers. Thus none of the above queries suit my need. Does anyone have a better idea?

Kind regards,
Jens Ivar