SQL全角半角标点互转函数
--full2half/*全角(Fullwidth)转换为半角(Halfwidth)*/ CREATE FUNCTION .(@String nvarchar(max)
)
RETURNS nvarchar(max)
AS
BEGIN
DECLARE @chr nchar(1)
DECLARE @i int
SET @String = REPLACE(@String,N' ',N' ')
SET @i = PATINDEX(N'%[！-～]%' COLLATE Latin1_General_BIN,@String)
WHILE @i > 0
BEGIN
SET @chr = SUBSTRING(@String,@i,1)
SET @String = REPLACE(@String,@chr,NCHAR(UNICODE(@chr)-65248))
SET @i = PATINDEX(N'%[！-～]%' COLLATE Latin1_General_BIN,@String)
END
RETURN @String
END
GO
页:
[1]