Thanks very much. I think that will do the trick. I was getting there but was uncertain about it and that really helps me out.

The update statement would look like this:

update product set productid = 'XY' + productid

As is, that would update all records, but apparently I need to know how to break...

It's pretty simple structure and no index on column being updated.

CREATE TABLE [dbo].[Product](

[ProductUID] [int] IDENTITY(1,1) NOT NULL,

[EntityUID] [int] NOT NULL,

[ProductID] [varchar](30) NULL,

[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_Visit_LastUpdate_1] DEFAULT...

OK. I can buy that. What is the best way to break it up like you suggest? I've been trying to look into that but see mixed messages on how...