SqlServer2005中查询用分隔符分割的内容中是否包含其中一个内容

SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
/*
--=============================================
--Author:<饭饭>
--Createdate:<2011-10-19>
--Description:<查询分隔符分割的数据是否包含某项>
--=============================================
*/
ALTERFunction[dbo].[HasKey](@DataStrvarchar(100),@keyvarchar(8))
returnsint
as
begin
declare@return_strvarchar(50)
declare@isokbit
declare@posiint
set@isok=0
--set@DataStr="a,aaaa,aaaddd,ffass"
--set@key="aaaa"
set@DataStr=@DataStr+","
whilelen(@DataStr)>0and@isok=0
begin
set@posi=charindex(",",@DataStr)
set@return_str=replace(substring(@DataStr,1,charindex(",",@DataStr)),",","")
set@DataStr=substring(@DataStr,@posi+1,len(@DataStr))
if(@return_str=@key)
begin
set@isok=1
break
end
end
return@isok
end
GO