Frank,

You can use sys(2015) but the sys(2015) only return up to 10 characters.

select sys(2105) as cuid, * from tablename order by 1.

if you need more than 10 character of unique id you can concatenate as couples of sys(2105).
example: sys(2015) + sys(2015)


Rene

>By any chance anyone knows of a routine/function similar to that in sql, newid(), to generate random records from a table in vfp?
>
>The sql select statement, select top 10 id from tblTest order by newid()
>
>Thanks.
>
>Frank