SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Test (Id int, MyText nvarchar(255))
INSERT INTO Test (Id, MyText) values  (1, '<>');
INSERT INTO Test (Id, MyText) values  (2, '><');
2 rows affected

SELECT id, MyText, CONVERT(varbinary(510), MyText) FROM Test


id
MyText
(No column name)


1
<>
0x3C003E00

2
><
0x3E003C00


UPDATE Test SET MyText = TRANSLATE(MyText, '<>', NCHAR(706)+NCHAR(707));
2 rows affected

SELECT id, MyText, CONVERT(varbinary(510), MyText) FROM Test


id
MyText
(No column name)


1
˂˃
0xC202C302

2
˃˂
0xC302C202


DROP TABLE dbo.Test;