By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Sorting order by unique pattern

mb60
P: 36
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,Echinodermata,Amphibia, BIrds, Cnidaria, Echinodermata...
Apr 5 '10 #1

✓ answered by 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)>

Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Create a new field with the Datatype of Number, Then assign the numbers in the order you want and sort on them.

Linq ;0)>
Apr 5 '10 #2

mb60
P: 36
Thank You sir.
it worked.
Apr 5 '10 #3

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Apr 5 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.