SortExpression with Brackets

[Tab Alleman]

I've got a grid bound to a dataset that contains a column named "[$Colld]".      The brackets are actually a part of the column name.
For this column on my grid, I've got 

 

 

 

DataField="[$Colld]"

and that works fine, the data shows in the grid.   However, I've also got   

 

 

 

 

 

SortExpression="[$Colld]"

and when I click on the column header to sort by that column, I get this error:
Cannot find column $Colld.

It's like the brackets get ignored when they are in the SortExpression. 
So I tried:    

 

 

 

 

 

SortExpression="[[$Colld]]"

but I get this error:
[[$Colld]] is neither a DataColumn nor a DataRelation for table ICRData.

How can I escape the brackets so that the SortExpression is accurately interpreted as "[$Colld]" ??  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

[Princy]

Hello Tab Alleman,

You got this error because square brackets are not supported in RadGrid field names. Please take a look at the following Forum post which discusses similar kind of issue.

Sorting issue in RadGrid - columns start and end with brackets

Thanks,
Princy.