Hi,
How to Update Following Data
create table tempEmp
(
Id int primary key identity(1,1),
Empname nvarchar(20),
EmpCode nvarchar(100)
)
select * from tempEmp
insert into tempEmp values ('John',1234567890)
insert into tempEmp values ('Joseph',78045678901)
insert into tempEmp values ('esJohn',987234567890)
/* after 3 characters only i need update like this (But Remaining digits Must be equal) */
/*outoput i need like this */
1 John 1231111111
2 Joseph 78011111111
3 esJohn 987111111111
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com