I'm trying to create a "row number" column in SQL. I need a unique
record ID. Is there a function or command or some "cool" trick that
will do this for me using the BDE and .DBF's?

I need to be able to do this in SQL rather than Delphi code.

Thanks!

Bill
Bill Artemik
Programmer / Analyst
b...@droste1.com

"The number one CAUSE of computer problems
     is computer SOLUTIONS."

No. If your database has some type of autonumber generation feature for
surrogate keys (and most do) the number generation is handled by the DBMS. I
know of no SQL dialect that supports this.

--
Bill