ACCD                 ACCC
-------------------- --------------------
40702810700000001202 20202810300000000000
40702810300000000111 20202810300000000000
20202810300000000000 30102810500000000000
20202810300000000000 40702810900000001204
20202810300000000000 20202810700002222222

ACCD                 ACCC                          ALL20202                ABC
-------------------- --------------------          --------------------    --------------------
40702810700000001202 20202810300000000000          20202810300000000000    40702810700000001202 
40702810300000000111 20202810300000000000          20202810300000000000    40702810300000000111 
20202810300000000000 30102810500000000000          20202810300000000000    30102810500000000000          
20202810300000000000 40702810900000001204          20202810300000000000    40702810900000001204          
20202810300000000000 20202810700002222222          20202810300000000000    20202810700002222222          

CASE  SUBSTRING(p.ACCD, 1, 3)
   WHEN '202' THEN p.ACCC
       else p.ACCD
END

CASE  
	WHEN p.ACCD LIKE '20202%' AND p.ACCD LIKE '20202%' THEN p.ACCD
	WHEN p.ACCD LIKE '20202%' THEN p.ACCC	
	ELSE p.ACCD
END as ABC

CASE  
	WHEN p.ACCD LIKE '20202%' AND p.ACCD LIKE '20202%' THEN p.ACCD
	WHEN p.ACCD LIKE '20202%' THEN p.ACCC	
	ELSE p.ACCD
END as ABC

CASE  
		WHEN p.ACCD LIKE '20202%' and p.ACCC LIKE '20202%' THEN p.ACCD
		WHEN p.ACCD LIKE '20202%' and pACCC NOT LIKE '20202%' THEN p.ACCD
	     WHEN p.ACCD NOT LIKE '20202%' and p.ACCC LIKE '20202%' THEN p.ACCC
	 END as ALL20202,
	  CASE  
		WHEN p.ACCD LIKE '20202%' and p.ACCC LIKE '20202%' THEN p.ACCC
		WHEN p.ACCD LIKE '20202%' and p.ACCC NOT LIKE '20202%' THEN p.ACCC
	     WHEN p.ACCD NOT LIKE '20202%' and p.ACCC LIKE '20202%' THEN p.ACCD
	 END as ABC,