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

public partial class UserDefinedFunctions
{
 [Microsoft.SqlServer.Server.SqlFunction]
 public static SqlString SplitString(string input, string pattenChars,int pos=0)
 {
 string strReturn = string.Empty;

 if (string.IsNullOrEmpty(input) || string.IsNullOrEmpty(pattenChars))
 {
 strReturn = string.Empty;
 }
 else
 {
 string[] st = input.Split(pattenChars.ToCharArray());
 if(pos < st.Length)
 {
 strReturn = st[pos];
 }
 }
 return new SqlString (strReturn);
 }

 [Microsoft.SqlServer.Server.SqlFunction]
 public static SqlInt32 Eval(string input)
 {
 int rt =0;

 if (string.IsNullOrEmpty(input))
 {
 rt = 0;
 }
 else
 {
 rt = (int)(new DataTable().Compute(input,""));
 
 }
 return new SqlInt32(rt);
 }
}