SourceCode/PROMS/SQL/ChangeXMLfield.sql

3 lines
120 B
SQL

update Formats
set Data = Cast(Replace(Cast(Data as nvarchar(max)),'\xA033 13','SECTION') as XML)
where Name = 'RGESAM1'