filter not works when i use words "AND", "OR" in filter expression

[Igor Ashmetkov]

     Hello.
I`m using RadGrid with SqlDataSource. Filter in RadGrid work fine except using such words as "AND", "OR" in filter expression (for example "mike and smith"). In this situation filter is reseting and grid not filtered.
I didn`t find any post with this question.
Any ideas?

[Elliott]

is all the filtering done in code?  this snippet works but filtering on the page is disabled

private string AppendFilterExpression(string filterExpression)
{
    StringBuilder sb;
    sb = new StringBuilder(rgEditOrder.MasterTableView.FilterExpression);
    if (filterExpression == string.Empty)
        return sb.ToString();
    if (sb.ToString() != string.Empty)
    {
        sb.Append(" AND ");
    }
    sb.Append(filterExpression);
    return sb.ToString();
}

the syntax is [UniqueName] = value

[Mira]

Hello Marianne,

The AND and OR words (with capital letters) are reserved words for the Telerik RadGrid and cannot be used in the filter values.
However, when using for example "mike and smith" (and with small letters), the grid will interpret it as a valid string and filter for it as you can see in this demo.

I hope this helps.

Kind regards,
Mira
the Telerik team

[Elliott]

I misunderstood the question - but Mira cleared up my confusion (and answered Igor's question in the process)