数据库字符串处理 很不错

CREATE FUNCTION dbo.Split(@Str VARCHAR(8000))
RETURNS
@List TABLE
(
INDEXNO INT
,OBJECT VARCHAR(100)
)
AS
BEGIN
DECLARE @OBJECT AS VARCHAR(100)
DECLARE @INDEX AS INT
SET @INDEX=1
WHILE CHARINDEX(',',@Str)>0
BEGIN
 SET @OBJECT=SUBSTRING(@Str,1,CHARINDEX(',',@Str)-1)
 INSERT INTO @List
 (
  INDEXNO
  ,OBJECT
 )
 SELECT
  @INDEX
  ,@OBJECT
 SET @Str=STUFF(@Str,1,CHARINDEX(',',@Str),'')
 SET @INDEX=@INDEX+1
END
RETURN
END
------------------------------------------------------------------------
DECLARE @STR VARCHAR(500)