SQL Server 2022

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

CREATE TABLE pp (
function_code NVARCHAR(50),
reverse_reason NVARCHAR(50) NULL,
reason_code NVARCHAR(50) NULL,
policy_no NVARCHAR(50) NULL,
agent_code NVARCHAR(50) NULL,
tran_date NVARCHAR(50) NULL);

INSERT INTO pp (function_code,reverse_reason,reason_code,policy_no,agent_code,tran_date) VALUES
('CA','','UR','*****','X22****875','102/11/01'),
('CA','2','UR','*****','R12****296','112/04/01'),
('CA','','UR','*****','B22****899','106/12/01'),
('CA','','UR','*****','B12****650','102/11/01'),
('CA','','UR','*****','Q22****296','106/12/01'),
('CA','','UR','*****','L12****081','106/12/01'),
('CA','','UG','*****','S22****735','103/10/01'),
('CA','','UG','*****','N22****610','106/12/01'),
('CA','','T4','*****','Q22****171','102/09/01'),
('CC','','T4','TW0*****','F22****895','109/12/31'),
('CC','','T4','TW0*****','B12****269','111/08/31'),
('CC','','T4','TW0*****','H22****456','108/09/30'),
('CC','','T4','TW0*****','L12****267','108/12/31'),
('F1','','20','160*****9897','T12****600','108/03/07'),
('F1','2','20','176*****2974','Q12****583','108/03/07'),
('F1','3','20','171*****0666','T12****286','108/03/07'),
('F1','','10','178*****3835','T22****421','112/07/24'),
('F1','','16','147*****7693','X12****674','103/07/14');

SELECT *
FROM pp;

function_code	reverse_reason	reason_code	policy_no	agent_code	tran_date
CA		UR	*****	X22****875	102/11/01
CA	2	UR	*****	R12****296	112/04/01
CA		UR	*****	B22****899	106/12/01
CA		UR	*****	B12****650	102/11/01
CA		UR	*****	Q22****296	106/12/01
CA		UR	*****	L12****081	106/12/01
CA		UG	*****	S22****735	103/10/01
CA		UG	*****	N22****610	106/12/01
CA		T4	*****	Q22****171	102/09/01
CC		T4	TW0*****	F22****895	109/12/31
CC		T4	TW0*****	B12****269	111/08/31
CC		T4	TW0*****	H22****456	108/09/30
CC		T4	TW0*****	L12****267	108/12/31
F1		20	160*****9897	T12****600	108/03/07
F1	2	20	176*****2974	Q12****583	108/03/07
F1	3	20	171*****0666	T12****286	108/03/07
F1		10	178*****3835	T22****421	112/07/24
F1		16	147*****7693	X12****674	103/07/14

No	function_code	reverse_reason	reason_code	policy_no	agent_code	tran_date
1	CA		T4	*****	Q22****171	102/09/01
1	CA		UG	*****	N22****610	106/12/01
1	CA		UR	*****	B22****899	106/12/01
1	CA	2	UR	*****	R12****296	112/04/01
1	CC		T4	TW0*****	B12****269	111/08/31
1	F1		10	178*****3835	T22****421	112/07/24
1	F1		16	147*****7693	X12****674	103/07/14
1	F1		20	160*****9897	T12****600	108/03/07
1	F1	2	20	176*****2974	Q12****583	108/03/07
1	F1	3	20	171*****0666	T12****286	108/03/07