Remove characters from recordset permanently I have some data in this format:

52-681-Functional-EHT
53-682-Functional-EGT
52-683-Functional-EZT
51-684-Functional-EYT
59-685-Functional-E5T


And I want to remove the interior '-Functional' permanently with a sql statement so that my records would now look like...

52-681-EHT
53-682-EGT
52-683-EZT
51-684-EYT
59-685-E5T


All my research leads me to Replace but that seems to just be on a select and can't quite figure out how to form it into an appropriate update statement. Again, I want to remove the string FOREVER.



Creation script:

create table part (
id int identity(1,1) PRIMARY KEY,
Partname nvarchar(50))

insert into Part (Partname)
values ('52-681-Functional-EHT'),
('53-682-Functional-EGT'),
('52-683-Functional-EZT'),
('51-684-Functional-EYT'),
('59-685-Functional-E5T')
Is there a reason this simple update doesn't work for you?

update part set partname = replace(partname,'functional-','')

select * from part