Code Name IN.01 Andaman IN.02 Andhra Pradesh IN.03 Assam IN.05 Chandīgarh IN.06 Dādra IN.07 NCT IN.09 Gujarāt IN.10 Haryana
StateCode 02 10 11 12 13 14 16
SatateCode Name 10 Haryana 02 Andhra Pradesh
UPDATE T1.Name = T2.StateCode FROM Table1 T1 INNER JOIN Table2 T2 ON T2.StateCode==REPLACE(T1.StateCode,'IN.','')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)