Re: Order By

From: Chino <chino81_at_gmail.com>
Date: 19 Apr 2006 22:25:33 -0700
Message-ID: <1145510733.461598.65170@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 - 00:25:33 CDT