col1
AB:5          
AB:9 EF:5        
EF:180                    
CD:12 AB:12   

Col1               AB       CD       EF
AB:5               5
AB:9 EF:5          9                 5
EF:180                              180
CD:12 AB:12        12       12      

select	col1,
	case 	when col1 like '%AB%'
		then substring(col1, charindex('AB', col1) + 3, charindex(' ', col1 + ' ', charindex('AB', col1)) - charindex('AB', col1) - 3)
		end,
	case 	when col1 like '%CD%'
		then substring(col1, charindex('CD', col1) + 3, charindex(' ', col1 + ' ', charindex('CD', col1)) - charindex('CD', col1) - 3)
		end,
	case 	when col1 like '%EF%'
		then substring(col1, charindex('EF', col1) + 3, charindex(' ', col1 + ' ', charindex('EF', col1)) - charindex('EF', col1) - 3)
		end
from	tbl