Yes, it can work on an XML column too. Here is an example

DECLARE @t TABLE (id int, data XML)

INSERT INTO @t(id, data) SELECT 1, '

'

INSERT INTO @t(id, data) SELECT 2, '

'

UPDATE @t

SET data.modify('

delete (Employees/Employee[@Team="SQL Server"]/@city)

')

SELECT * FROM @t