Boris

Thanks you, this looks nice. I see how this would work without an extra table.


Agnes
>

>CREATE CURSOR crsTest(Fld1 int)
>INSERT INTO crsTest VALUES(0)
>select b1+b2+b3+b4+b5+b6+b7+b8+b9+b10+b11+b12 AS Numbers;
>from      (select 0 b1  FROM crsTest union select 1 b1  FROM crsTest)  t1;
>full join (select 0 b2  FROM crsTest union select 2    b2 FROM crsTest)  t2 ON 1=1;
>full join (select 0 b3  FROM crsTest union select 4    b3 FROM crsTest)  t3 ON 1=1;
>full join (select 0 b4  FROM crsTest union select 8    b4 FROM crsTest)  t4 ON 1=1;
>full join (select 0 b5  FROM crsTest union select 16   b5 FROM crsTest)  t5 ON 1=1;
>full join (select 0 b6  FROM crsTest union select 32   b6 FROM crsTest)  t6 ON 1=1;
>full join (select 0 b7  FROM crsTest union select 64   b7 FROM crsTest)  t7 ON 1=1;
>full join (select 0 b8  FROM crsTest union select 128  b8 FROM crsTest)  t8 ON 1=1;
>full join (select 0 b9  FROM crsTest union select 256  b9 FROM crsTest)  t9 ON 1=1;
>full join (select 0 b10 FROM crsTest union select 512  b10 FROM crsTest) t10  ON 1=1;
>full join (select 0 b11 FROM crsTest union select 1024 b11 FROM crsTest) t11 ON 1=1;
>full join (select 0 b12 FROM crsTest union select 2048 b12 FROM crsTest) t12 ON 1=1;
>ORDER BY Numbers
>