I would strongly recomend to make backup of your data before runnung code like that.
DECLARE @Counter int
SET @Counter = 0
UPDATE [LFMTX].[dbo].[Toc]
SET @Counter = @Counter + 1, [Name] = 'Pre-'+ CAST(@Counter AS varchar(10))
WHERE [Name] like 'Pre-04/07/2006-4-%'
>i am new in SQL Server 2005.i want to update multi raw in SQl Server Table.
>each raw update fields with new value.i am attaching code here.
>
>declare @counter int
>set @counter = 0
>
>SELECT * FROM [LFMTX].[dbo].[Toc]
>where Name like 'Pre-04/07/2006-4-%'
>
>---Need a Help from here
>
>while @counter < TOTAL RECORD VALUE
> begin
> UPDATE [LFMTX].[dbo].[Toc]
> SET [Name] = 'Pre-'+ cast(@counter as char)
> where Name like 'Pre-04/07/2006-4-%'
> set @counter = @counter + 1
>end
>
>
>Best Regards
>Mazahir
--sb--