• You don't need the replace function here. Simply set the Description value to your desired value (in this case, accountID + description)

    update c

    set [Description] = t.accountid + ' - ' + [Description]

    FROM [Document].[dbo].[DOC.Client] as c

    inner join [Reporting].[dbo].[Tran] as t on t.Id = c.accountindex

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden