[Solved] forcing numerical sort on a varchar field

[John Chatt]

I would like to sort a column by numerical and alphabetical.
for instance I have a varchar() column that contains mostly numbers and I would like it to be sorted 1,4,7,10,20 instead of 1,10,20,4,7.
I want it this way because the column contains data like "1 Bat", "1 Cat", "1 Dog", "10 Bats", "2 Cats", "5 Dogs".....

Is this possible with the RadGrid?

[Princy]

Hi,

The column sorts based on the datatype. Since your column contains both number and string  ,a suggestion would be to perform custom sorting which will skip the default sort behavior and allow you to use a custom sort for a column.

Thanks,

Princy