Hi all,

Did RonKyle post a sample of his solution as I have a little task which could use his technique.

If not perhaps he could post a sample so we may...

Thanks for all your help Mike, that seems to work on my small test. Will try it out on a few more records to make sure.

Thank you again

Steve

This is code which updates correct row but also resets all others to NULL

Steve

declare @LastName varchar(50)

declare @FirstName varchar(50)

declare @payroll varchar(50)

declare curs1 cursor for select Inf_LastName,Inf_FirstName,Inf_EmployeeNo from VT_MailInfo where...

Mike,

The code below will update the correct rows but will reset those not marked with dup bit set to NULL!

Steve

I may have confused myself and you on tables names.

I am calling the primary table my mail info which is the table that needs to have the payroll number updated.

The...

Thank you for replies all.

I have managed to get full first names now and tried Mikes  method.

As I had set up a DupMail bit for another reason I used this...

Thank you for replies all.

I have managed to get full first names now and tried David method.

As I had set up a DupMail bit for another reason I used this...