Sql Server Select  Query value of column from another column
                            
                         
                        
                     
                 
                
                    Hi,
 
 I have table below 
 
 exiting
 col1        col2          col3
 1000  	2203A       2
 1375  	2203        2
 482   	2237         3
 1000 	2237A       3
 
 i want a select query to get data AS BELOW for col2 with suffix(2203A) should get COL1 value of suffixless(2203) in col1
 
 desired OUTPUT
 col1       col2           col3
1375    2203A         2
 1375    2203            2
 482       2237            3
 482       2237A          3