如何提取汉字

 方法1:

declare
@str varchar(100),
@i int
set @str='sd深3刻的g飞45机dsf扩大'
set @i=1
while @i<=len(@str)
begin
if len(unicode(substring(@str,@i,1)))<5
begin
set @str=stuff(@str,@i,1,'');
print @str
end
else
set @i=@i+1;
end
select @str

 

方法2:

create function getnewstr
(@oldstr varchar(100))
returns varchar(100)
as
begin
declare @i int
set @i = 1
while @i <= len(@oldstr)
if substring(@oldstr, @i, 1) like('[^吖-座]')
set @oldstr = replace(@oldstr, substring(@oldstr, @i, 1), '')
else
set @i = @i +1
return @oldstr
end
go

select result = dbo.getnewstr('11adfasd1中国aadfaa')
select result = dbo.getnewstr('11adsf1中国aaadfadsa广东eodsa深adfa圳')

drop function dbo.getnewstr