IN.02 Andhra Pradesh
02 Andhra Pradesh
UPDATE T1.Name = T2.StateCode
FROM Table1 T1
INNER JOIN Table2 T2 ON T2.StateCode==REPLACE(T1.StateCode,'IN.','')
This action is not allowed at this time as the site is in read-only mode. Please try again later.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)