I'm not sure if this is do-able.
I'm doing a select on a result set that is XML data.
select replace([theDate], 'images1', 'images') from theTemp
I need to do it with a replace statement and am getting
Argument data type xml is invalid for argument 1 of replace function.