Matching id with ignoring 1 character

Nope, it just evaluates string which is removed ' character. Data isn’t updated.

findrow = MSMEDT.AsEnumerable.Where(Function(x) x(3).ToString.Equals(currentrow(7).ToString)).FirstOrDefault()

Which is dt1 you said in the first post? (MSMEDT or datatable for currentrow?)

Regards,