DECLARE @checksum TABLE( CustomerNo CHAR(17) ,Address CHAR(40))INSERT INTO @checksumSELECT '00000000014331462','A15 Block No.: 3' UNION ALLSELECT '00000000061051462','F23 Block No.: 5'SELECT CHECKSUM(CustomerNo,Address)FROM @checksum
SELECT HASHBYTES('MD5', CustomerNo + Address) ,BINARY_CHECKSUM(CustomerNo, Address) ,CHECKSUM(CustomerNo, Address)FROM @checksum