sql server 中判断是否为中文的函数

USE [master]
GO
/****** Object:  UserDefinedFunction [dbo].[getChina]    Script Date: 07/08/2010 09:41:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER  function [dbo].[getChina](@str nvarchar(1000))
returns nvarchar(1000)
as
begin
declare @strall nvarchar(1000)
set @strall=''
declare @inti int
set @inti=0
declare @strTemp nvarchar(100)
set @strTemp=''
while(@inti<=len(@str)-1)
begin
 set @strTemp=substring(@str,@inti,1)
 if @strTemp like '%[吖-做]%'
 set @strall=@strall+@strTemp
 set @inti=@inti+1
end
return @strall

end