> -----Original Message-----
> The maximum sort record is 64KB in size.
>
> What is the total length of the columns in the SELECT clause?

Sizes are:

BIGINT x 4
TIMESTAMP x 2
VARCHAR(1) x 1
VARCHAR(15) x 1
VARCHAR(100) x 1
VARCHAR(2500) x 1
VARCHAR(32000) x 1

> > Without the DISTINCT everything is OK.
>
> This is curious...

This is what threw me :-)

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered Forum