Sorting on a LONG column

From: Thomas P. Boudalier <tboudalier_at_apsydev.com>
Date: 1997/06/02
Message-ID: <01bc6f82$8ea01a20$2a6703c2@tombou>#1/1

I am trying to design a query that sorts on a LONG column. Indeed this is not directly possible under Oracle, but in other database engines (i.e. Microsoft SQL Server), I can convert to a limited char type on which I can sort:
select ... order by Convert(char(255), Comment)

Is there a way to do the same?
- convert a LONG datatype to a VARCHAR datatype

or directly sort on a LONG datatype?

Thanks

Thomas Boudalier
Apsylog Development Received on Mon Jun 02 1997 - 00:00:00 CDT