Well, John, I know you can do this:

this.AnimalsDt.DefaultView.Sort = "EarTag, AnotherColumn, Etc" ;

but, whether or not you can do this;

this.AnimalsDt.DefaultView.Sort = "EarTag.Substr(1,8), Eartag.Substr(Eartag.length-5)";

I'm not sure. Try it and see if it works.

~~Bonnie

>I need to sort a datatable / view on an expression.
>
>In VFP you can use INDEX ON LEFT(ALLTRIM(Eartag),8)+RIGHT(ALLTRIM(Eartag),5)
>
>I can sort the column using the following code.
>
>

>this.AnimalsDt.DefaultView.Sort = "EarTag ASC" ;
>

>
>How sort it using an expression using C#.
>
>Thanks
>
>John