gistfile1.sql

CREATE TRIGGER Benefits.AddressHashcode
   ON  Benefits.Addresses
   INSTEAD OF INSERT
AS 
BEGIN
	SET NOCOUNT ON;

	INSERT INTO addresses
	SELECT City, State, Zip, Street1, Street2, County,
		ISNULL(
			Hashcode, 
			HASHBYTES('SHA1', '|' + ISNULL(City, '<NULL>') + '|' + 
				'|' + ISNULL(State, '<NULL>') + '|' + 
				'|' + ISNULL(Zip, '<NULL>') + '|' + 
				'|' + ISNULL(Street1, '<NULL>') + '|' + 
				'|' + ISNULL(Street2, '<NULL>') + '|' + 
				'|' + ISNULL(County, '<NULL>') + '|')
			)
	FROM inserted;

END
GO