创建标量值函数判断某个字段是否包含中文

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date, ,>
-- Description:    <Description, ,>
-- =============================================
ALTER FUNCTION [dbo].[IsHaveChinese](@nvString varchar(4000))
RETURNS varchar(100)
AS
BEGIN
declare @iCount int
,@iPos int
,@vReturnValue varchar(20)
select @iCount=len(@nvString)
,@iPos=1
if(ltrim(rtrim(@nvString))='')
begin
set @vReturnValue='yes'
goto lbl_Return
end
while(@iPos<=@iCount)
begin

if(ascii(substring(@nvString,@iPos,1))>=127) --通过ascii码值进行循环判断
begin
set @vReturnValue='yes'
break;
end
else if(@iPos=@iCount)
begin
set @vReturnValue='no'
end
set @iPos=@iPos+1
end
lbl_Return:
return(@vReturnValue)

END