Thank you for the response Tomasz The query works like a charm! It is simpler & faster than the one I came up with & faster
Update analog a Set a.Name = (Select a1.name From analog a1 Where a.tag_no =
a1.tag_no + 1238)
where a.tag_no >= 3671 and a.tag_no <= 3690
Regards
jack
