把一个字符串分隔成一列

--说明[f_splitstr]（字段名，分隔符）
ALTER   function   [dbo].[f_splitstr](@SourceSql   varchar(max),@StrSeprate   varchar(100))   
  returns   @temp   table(F1   varchar(100))   
  as     
  begin   
  declare   @ch   as   varchar(100)   
  set   @SourceSql=@SourceSql+@StrSeprate     
  while(@SourceSql<>'')   
                  begin   
                  set   @ch=left(@SourceSql,charindex(',',@SourceSql,1)-1)   
  insert   @temp   values(@ch)   
  set   @SourceSql=stuff(@SourceSql,1,charindex(',',@SourceSql,1),'')   
                  end   
  return   
  end

用法：sql+= " and '" + id + "' in (select * from  f_splitstr(courseId,',')) ";