Quick example of a simple method, normally does the job but strictly speaking it is reversible although it would require a hash-table approach.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

SD_ID INT IDENTITY(1,1) NOT NULL

,Firstname varchar(50) not null

,Latname varchar(50) not null

,dob datetime not null

,addressline1 varchar(50) null

,adressline2 varchar(50) null

,city varchar(50) null

,postalcode varchar(20) null

);

INSERT INTO @SAMPLE_DATA

(

Firstname

,Latname

,dob

,addressline1

,adressline2

,city

,postalcode

)

VALUES

('Albert','Einstein','1879-03-14','Banhofstrasze',NULL,'ULM','')

,('Alexander Graham','Bell','1847-03-03',NULL,'','Edinburgh','EH1-17')

SELECT

SD.SD_ID

,ABS(CHECKSUM(REVERSE(Firstname )) * SIGN(DATALENGTH(Firstname ))) AS Firstname

,ABS(CHECKSUM(REVERSE(Latname )) * SIGN(DATALENGTH(Latname ))) AS Latname

,ABS(CHECKSUM(REVERSE(dob )) * SIGN(DATALENGTH(dob ))) AS dob

,ABS(CHECKSUM(REVERSE(addressline1)) * SIGN(DATALENGTH(addressline1))) AS addressline1

,ABS(CHECKSUM(REVERSE(adressline2 )) * SIGN(DATALENGTH(adressline2 ))) AS adressline2

,ABS(CHECKSUM(REVERSE(city )) * SIGN(DATALENGTH(city ))) AS city

,ABS(CHECKSUM(REVERSE(postalcode )) * SIGN(DATALENGTH(postalcode ))) AS postalcode

FROM @SAMPLE_DATA SD;

Results

SD_ID Firstname Latname dob addressline1 adressline2 city postalcode

----------- ----------- ----------- ----------- ------------ ----------- ----------- -----------

1 908524580 32315969 182191641 1453234408 NULL 60048253 0

2 1585822690 1232888188 1701236231 NULL 0 1631151168 447240984