SourceCode/PROMS/SQL Data Tools/ReplaceSquaresWithDashesInTables.sql
2023-05-09 18:21:47 +00:00

2 lines
219 B
SQL

update grids set data = cast(replace(cast(data as nvarchar(max)),'{\f1\fnil\fcharset0 Courier New;}','{\f1\fnil\fcharset0 FreeMono;}') as xml)
where cast(data as nvarchar(max)) like '%{\f1\fnil\fcharset0 Courier New;}%'