I am trying to modify an XML string to replace the value of a node with something else. The end goal will be mass encrypting account numbers in a column but for the time being, I'm just trying to replace the one in the XML string.

When I execute this, I get "Command completed successfully" even though I am trying to return data.

```
DECLARE @xml XML = '<optional><account>155555555</account></optional>'

SET @xml.modify('replace value of (/optional/account/text())[1] with "' + (
              SELECT 'ABC-' + ParamValues.item.value('.', 'varchar(max)')
              FROM @xml.nodes('/optional/account') AS ParamValues(item)
       )+ '"')

SELECT @xml

```

Any thoughts as to why this isn't replacing the account number in the XML string with the `ABC-Account Number Here` and returning it?