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