ALTER FUNCTION [dbo].[f_getchinese]
(
@chinese nvarchar(max)
)
RETURNS nvarchar(100)
AS
BEGIN
WHILE PATINDEX('%[^吖-座]%',@chinese) > 0
-- SELECT 'Navicat for SQL Server'
BEGIN
SET @chinese = STUFF(@chinese,PATINDEX('%[^吖-座]%',@chinese),1,N'')
END
RETURN @chinese
END
sql获取字符串中的中文
最新推荐文章于 2022-11-07 14:55:59 发布