Serge Rielau <sr*****@ca.ibm.com> wrote in message news:<2s*************@uni-berlin.de>...
Which version are you on? This limit has long since been lifted.
However you cannot order based on a LONG VARCHAR.
You should be able to cast the LONG VARCHAR to a VARCHAR and order on
that though.
Note: You may need a syteem temp tablespace of appropriate page size.
Cheers
Serge
I'm using 8.2
It's a CLOB Field (whoops)
Casting to varchar(32000) worked fine :) (32K is wide enough to truncate)
I'd hope we didnt need over varchar max lenght so soon :)
Thanks
Alexandre