insert into T2 values('12345','ABCDEF','98765','PQRST')
insert into T2 values('13245','HIJKLM','45678','VWXYZ')
expected output after we apply the update query to T1.I am here looking for the "update query" to T1.
select * from T1
It means 5th character to 10th character of C1 of T1 should be replaced by C3 of T2,when 5th to 10th charecter of C1 of T1 matches with the C1 of T2.similary
10th character to the last character of C1 of T1 should be replaced by C4 of T2,when 10th to last charecter of C1 of T1 matches with the C2 of T2.
Hence the third row from T1 is unchaged as there is no matching record from T2.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.