How about this:

FUNCTION getNewId

loGUID = CreateObject ("Scriptlet.Typelib")
lcGUID = SUBSTR (loGUID.GUID, 2, 36)
loGUID = NULL
RETURN lcGUID

...

SELECT TOP 10 MyTable.MyField, getNewId () AS GUID FROM MyTable ORDER BY GUID

HTH

>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()