Sorting order by unique pattern

[mb60]

In my database I have a column named CHAPTER. It contains the names of chapters like - Echinodermata, BIrds, Cnidaria, Amphibia etc., When I tried to sort them they are sorted either in ascending or descendig orders. I would like to sort the records in the following order
Amphibia,BIrds, Cnidaria,Echino dermata,Amphibi a, BIrds, Cnidaria, Echinodermata.. .

[missinglinq]

Create a new field with the Datatype of Number, Then assign the numbers in the order you want and sort on them.

Linq ;0)>

[mb60]

Thank You sir.
it worked.

[missinglinq]

Glad we could help!

Linq ;0)>