public partial class Utils
    {
        

        [SqlFunction(Name = "fn_Split", DataAccess = DataAccessKind.None, FillRowMethodName = "GetRowData1", IsDeterministic = true)]
        public static IEnumerable fn_Split(String StrToSplit, String Splitter)
        {
            List<TableRow1> ret = new List<TableRow1>();

            if (StrToSplit == null) 
                return ret;         
            
            if (String.IsNullOrEmpty(Splitter)) 
	        {
		        Char[] arr;
                arr = StrToSplit.ToCharArray();
                for (int i = 0; i < arr.Length; i++)
                {
                    ret.Add(new TableRow1(i + 1, arr[i].ToString()));
                }                
	        }
            else 
            {
                String[] arr;
                arr = StrToSplit.Split(new String[] {Splitter}, StringSplitOptions.None);
                for (int i = 0; i < arr.Length; i++)
                {
                    String tmp = arr[i];                    
                    ret.Add(new TableRow1(i+1, tmp));
                }
            }
                  
            return ret;            
        }

        [SqlFunction(Name = "fn_SplitByLen", DataAccess = DataAccessKind.None, FillRowMethodName = "GetRowData1", IsDeterministic = true)]
        public static IEnumerable fn_SplitByLen(String StrToSplit, Int32 Len)
        {
            List<TableRow1> ret = new List<TableRow1>();
            if (StrToSplit == null)
                return ret;

            if (Len <= 0)
                throw new ArgumentException("param len <= 0");

            for (int i = 0; i * Len < StrToSplit.Length; i++)
            {
                String tmp = StrToSplit.Substring(i * Len, Math.Min(Len, StrToSplit.Length - i * Len));
                ret.Add(new TableRow1(i + 1, tmp));
            }

            return ret;                       
        }



       

        //######################
        public static void GetRowData1(object o, out SqlInt32 RowNr, out SqlChars Data)
        {
            TableRow1 row = (TableRow1)o;
            RowNr = new SqlInt32(row.RowNr);
            Data = new SqlChars(row.Value);
        }

        public struct TableRow1
        {
            public int RowNr;
            public string Value;

            public TableRow1(int RowNr, string Value)
            {
                this.RowNr = RowNr;
                this.Value = Value;
            }
        }


 
        }