Re: Order By

From: Chino <chino81_at_gmail.com>
Date: 19 Apr 2006 22:25:33 -0700
Message-ID: <1145510733.461598.65170_at_i39g2000cwa.googlegroups.com>

Thanks for your input guys.

Unfortunately i am working off a legacy system and the data structure of nnnnnn-n is the foundation of the database so it would be too costly to amend it's data type and structure considering we are phasing out the legacy system.

I have opted with the use of the below work-around which does the job nicely.
select ... order by first_part(item_code), second_part(item_code);

Thanks once again for your input,
Ino Received on Thu Apr 20 2006 - 07:25:33 CEST

This message: [ Message body ]
Next message: Brian Selzer: "Re: Multiplicity, Change and MV"
Previous message: ralphbecket_at_gmail.com: "Lucid statement of the MV vs RM position?"
In reply to: Marshall Spight: "Re: Order By"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message