C#

BindingSource1.Sort = "Category, Rank, Mark"

DataView1.Sort = "Category, Rank, Mark"

vd.Department = (from dept in vd.Employees
                            select new Department
                            {
                                DepartmentID = dept.DivisionID,
                                DepartmentShortName = dept.Division,
                                DivisionIndex = divisons[dept.Division]
                            }).Distinct();

string[] values = FilterValue.Split(',');
StringBuilder bldr = new StringBuilder();
bool isFirst = true;

foreach (string s in values)
{
    if (!isFirst)
    {
        bldr.Append(",");
    }

    bldr.Append(string.Format("'{0}'", s));

    isFirst = false;
}

FilterValue = bldr.ToString();

Member 3708190 wrote:

in('CatagoryA, CatagoryB)

Member 3708190 wrote:

in('CatagoryA', 'CatagoryB')