SQL Convert full-width/half-width functions

/** * * * * SQL Conversion full-width/half-width function starts * * **/CREATE FUNCTIONConvertwordangle (@str NVARCHAR(4000),--the string to convert@flag bit --conversion flag, 0 converted to half angle, 1 conversion 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(@strN' 　  'N' ')     ELSE         SELECT @pat=N'%[!-~]%',@step=65248,@str=REPLACE(@strN' 'N' 　  ')         SET @i=PATINDEX(@patCOLLATE Latin1_General_BIN,@str)          while @i> 0         SELECT @str=REPLACE(@str,SUBSTRING(@str,@i,1),             NCHAR(UNICODE(SUBSTRING(@str,@i,1))+@step)),            @i=PATINDEX(@patCOLLATE Latin1_General_BIN,@str)             RETURN(@str) END /** * * * SQL Conversion full-width/half-width function ends * * * **/--Invocation Example:UpdateNewsSetTitle=Dbo. Convertwordangle (title,0);

SQL method for converting full-width or conversion half-width of characters

SQL Convert full-width/half-width functions