SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
  prod_num VARCHAR(14),
  owner VARCHAR(255) DEFAULT NULL,
  prod_date VARCHAR(255),
  pseudo_num VARCHAR(14),
);
INSERT INTO test (prod_num, owner, prod_date) VALUES
    ('260619275', 'Kieran', 'Feb 10, 2018'),
    ('316556232', 'Steven', 'Jan 6, 2020'),
    ('316556232', 'Steven', 'Jan 6, 2020'),
    ('625302534', 'Oliver', 'Feb 10, 2018'),
    ('811424845', 'Jeremy', 'Apr 12, 2018'),
    ('060961216', 'Quinlan', 'Jul 19, 2019'),
    ('713794360', 'Stuart', 'Nov 1, 2019'),
    ('553381666', 'George', 'Jan 8, 2019'),
    ('978519361', 'Macon', 'Nov 26, 2018'),
    ('352718969', 'Raphael', 'Jul 21, 2019'),
    ('803299478', 'Byron', 'Nov 26, 2019'),
    ('696124452', 'Dalton', 'Jul 17, 2018'),
    ('892088485', 'Keane', 'Jul 9, 2018'),
    ('817054190', 'Dillon', 'Apr 23, 2018'),
    ('500170097', 'Fitzgerald', 'Feb 11, 2019'),
    ('663252252', 'Thomas', 'Apr 10, 2018'),
    ('061983557', 'Alan', 'May 12, 2018'),
    ('492057435', 'Jarrod', 'Apr 16, 2018'),
    ('837802495', 'Shad', 'Mar 22, 2019'),
    ('725698187', 'Mark', 'Jul 22, 2018'),
    ('153352349', 'Akeem', 'Feb 19, 2018');
21 rows affected

SELECT prod_num, RIGHT(CONVERT(VARCHAR(32), HASHBYTES('SHA1', prod_num), 2), LEN(prod_num)) FROM test;


prod_num
(No column name)


260619275
EE3E590C7

316556232
B1D96AA86

316556232
B1D96AA86

625302534
750D7A4A9

811424845
824C463E3

060961216
1DE968C70

713794360
398384119

553381666
A991A088C

978519361
8DD8E2D0D

352718969
6D4A010C8

803299478
F27258D09

696124452
863AB7D53

892088485
D7AE51880

817054190
6B494FA9C

500170097
1CDB64F76

663252252
B80FF81E1

061983557
B1D23E1EF

492057435
B4B30E334

837802495
424B7E5C9

725698187
03746FF81

153352349
CBA265547


UPDATE test SET pseudo_num = RIGHT(CONVERT(VARCHAR(32), HASHBYTES('SHA1', prod_num), 2), LEN(prod_num));
21 rows affected

SELECT * FROM test;


prod_num
owner
prod_date
pseudo_num


260619275
Kieran
Feb 10, 2018
EE3E590C7

316556232
Steven
Jan 6, 2020
B1D96AA86

316556232
Steven
Jan 6, 2020
B1D96AA86

625302534
Oliver
Feb 10, 2018
750D7A4A9

811424845
Jeremy
Apr 12, 2018
824C463E3

060961216
Quinlan
Jul 19, 2019
1DE968C70

713794360
Stuart
Nov 1, 2019
398384119

553381666
George
Jan 8, 2019
A991A088C

978519361
Macon
Nov 26, 2018
8DD8E2D0D

352718969
Raphael
Jul 21, 2019
6D4A010C8

803299478
Byron
Nov 26, 2019
F27258D09

696124452
Dalton
Jul 17, 2018
863AB7D53

892088485
Keane
Jul 9, 2018
D7AE51880

817054190
Dillon
Apr 23, 2018
6B494FA9C

500170097
Fitzgerald
Feb 11, 2019
1CDB64F76

663252252
Thomas
Apr 10, 2018
B80FF81E1

061983557
Alan
May 12, 2018
B1D23E1EF

492057435
Jarrod
Apr 16, 2018
B4B30E334

837802495
Shad
Mar 22, 2019
424B7E5C9

725698187
Mark
Jul 22, 2018
03746FF81

153352349
Akeem
Feb 19, 2018
CBA265547

prod_num	(No column name)
260619275	EE3E590C7
316556232	B1D96AA86
316556232	B1D96AA86
625302534	750D7A4A9
811424845	824C463E3
060961216	1DE968C70
713794360	398384119
553381666	A991A088C
978519361	8DD8E2D0D
352718969	6D4A010C8
803299478	F27258D09
696124452	863AB7D53
892088485	D7AE51880
817054190	6B494FA9C
500170097	1CDB64F76
663252252	B80FF81E1
061983557	B1D23E1EF
492057435	B4B30E334
837802495	424B7E5C9
725698187	03746FF81
153352349	CBA265547

prod_num	owner	prod_date	pseudo_num
260619275	Kieran	Feb 10, 2018	EE3E590C7
316556232	Steven	Jan 6, 2020	B1D96AA86
316556232	Steven	Jan 6, 2020	B1D96AA86
625302534	Oliver	Feb 10, 2018	750D7A4A9
811424845	Jeremy	Apr 12, 2018	824C463E3
060961216	Quinlan	Jul 19, 2019	1DE968C70
713794360	Stuart	Nov 1, 2019	398384119
553381666	George	Jan 8, 2019	A991A088C
978519361	Macon	Nov 26, 2018	8DD8E2D0D
352718969	Raphael	Jul 21, 2019	6D4A010C8
803299478	Byron	Nov 26, 2019	F27258D09
696124452	Dalton	Jul 17, 2018	863AB7D53
892088485	Keane	Jul 9, 2018	D7AE51880
817054190	Dillon	Apr 23, 2018	6B494FA9C
500170097	Fitzgerald	Feb 11, 2019	1CDB64F76
663252252	Thomas	Apr 10, 2018	B80FF81E1
061983557	Alan	May 12, 2018	B1D23E1EF
492057435	Jarrod	Apr 16, 2018	B4B30E334
837802495	Shad	Mar 22, 2019	424B7E5C9
725698187	Mark	Jul 22, 2018	03746FF81
153352349	Akeem	Feb 19, 2018	CBA265547