• I know this topic is stale, but as long as your nText field is not too large, you can cast it as nvarchar and then use replace().

    example

    update testTable

    set testNtext = replace(cast(testNtext as nvarchar(1000)),'Nmero','Número')

    where testNtext like 'Nmero de Cuenta'