using System.Collections;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public class CLR_split
{
    [SqlFunction(FillRowMethodName="CharlistFillRow")]
    public static IEnumerable CLR_charlist_split(SqlString str,
                                                 SqlString delimiter)
    {
        return str.Value.Split(delimiter.Value.ToCharArray(0, 1));
    }

    public static void CharlistFillRow(object row, out string str)
    {
        str = (string)row;
        str = str.Trim();
    }

    [SqlFunction(FillRowMethodName="IntlistFillRow")]
    public static IEnumerable CLR_intlist_split(SqlString str)
    {
        return str.Value.Split((char[]) null,
                               System.StringSplitOptions.RemoveEmptyEntries);
     }

    public static void IntlistFillRow(object row, out int n)
    {
        n = System.Convert.ToInt32((string) row);
    }
}