With the detail provided, my suggestion would be to replace non-null values with a GUID. You may have some difficulty with the postal code column if you have any type of DRI to a postal code table or other type of postal code validation.
--Jeff Moden
Change is inevitable... Change for the better is not.