Hi.

I want to have a SQL-statement where a field is a running counter.

Something like this: SELECT field1, field2, ($i=$i+1) AS counter FROM table;

Is it possible?

John


Check out RUNSUM

Roy Lambert

Thx, Roy!