Claudio,
Yes if your application has full control over the table you can treat the autoinc PK field as a form of record number. In that case you would only need to find out how many records are in the table (n) and then draw a randowm PK (assuming that PKs are ordered 0,1,2,3,4,...,n-1) and then select that particular record.
It is always a good idea to have a PK in your table
Glad it helped you.
Einar
>This field (can be auto incremented) will simulate the recno().. right ?
>
>Also, turning it into a key will increase a lot the time for querys.. Nice one.. Deal, contract signed.. Thanks Einar !!
>
Semper ubi sub ubi.