Re: auto increment in select clause

> select count(*) as inc, t1.ref as ref
> from atable t1, atable t2
> where t2.ref <= t1.ref
> group by t1.ref
> ;

Thanx alot, it works nicely.
My form can now be populated in one sec less than before :) (I had to fill a recordset, then iterate throught it searching for the right value,
and finally return the position of the row in the recorset...) Received on Fri Jun 07 2002 - 05:56:19 CDT