-提取中文
IF OBJECT_ID('DBO.CHINA_STR') IS NOT NULL
DROP FUNCTION DBO.CHINA_STR
GO
CREATE FUNCTION DBO.CHINA_STR(@S NVARCHAR(100))
RETURNS VARCHAR(100)
AS
BEGIN
WHILE PATINDEX('%[^吖-座]%',@S) > 0
SET @S = STUFF(@S,PATINDEX('%[^吖-座]%',@S),1,N'')
RETURN @S
END
GO
PRINT DBO.CHINA_STR('呵呵ABC123ABC')
GO
DECLARE @Str VARCHAR(100),@len INT,@Rs VARCHAR(100)
SET @Str='dw天上人e间z'
SET @len=dbo.lenb(@str)
SET @Rs=''
WHILE @len>0
BEGIN
IF ASCII(LEFT(@str,1))>122
SET @Rs=@Rs+LEFT(@str,1)
SET @str=RIGHT(@Str,@len-1)
SET @len=@len-1
END
PRINT @Rs