Re: [SQL] SQL specified sort

2001-05-28 Thread [EMAIL PROTECTED]
Jeff, If you want to receive your data in an order which you specify manually, the easiest way to accomplish this is to add a separate field which contains an int4 value used by you to specify the order. E.g. myval | sortint _ H29| 2 214| 1 200| 3

[SQL] SQL specified sort

2001-05-28 Thread jeffrey morrison
I was wondering if you could help me out with a problem I'm having. Say for example I have data coming out like: H29 214 200 099 How would I use a sort to be able to make the output look like 214 H29 200 099 I don't believe their is a way to do an ORDER BY in a specific order. Any help you co