Sorting Problem

Hi All,i want to sort field values.

below are field values:

Allocation Method 5 -All Db

Allocation Method 10-All Db

Allocation Method 11 Db

Allocation Method 7 - All

Allocation Method 8 Db Plans

Allocation Method 9 Db

i tried alot but it is showing above values. it is showing 10 and 11 values before 7. i want sort like this 5,7,8,9,10,11.

Please help me

Thanks,

Prasad

Subject: Sorting Problem

Add a hidden field in the first column with the number parsed out of the value. Then sort by the hidden field.

@Middle should work. You will probably have to return a number instead of text.