SQL Server database full-angle conversion to half-width _mssql

Copy Code code as follows:

CREATE FUNCTION F_convert (
@str NVARCHAR (4000),--the string to convert
@flag bit--conversion flag, 0 converted to half angle, 1 convert to perfect angle
) RETURNS nvarchar (4000)
As
BEGIN
DECLARE @pat nvarchar (8), @step int,@i int, @spc int
IF @flag =0
SELECT @pat =n '%[! -~]% ', @step =-65248,
@str =replace (@str, n ', n ')
ELSE
SELECT @pat =n '%[!-~]% ', @step = 65248,
@str =replace (@str, n ', n ')
SET @i=patindex (@pat COLLATE latin1_general_bin, @str)
While @i> 0
SELECT @str =replace (@str,
SUBSTRING (@str, @i,1),
NCHAR (UNICODE (SUBSTRING (@str, @i,1)) + @step)
, @i=patindex (@pat COLLATE latin1_general_bin, @str)
Return (@str)
End
Go call: Update table1 set Column1=dbo.f_convert (column1,0);