Kevin,

the use of RECNO() and anything bound to ALIAS() is not recommended in SELECT SQL. But you can trick it
Add an extra column to your table, fill with the RECNO() and use this as as temp key

USE YourTable exclusive
ALTER TABLE YourTable ADD COLUMN iTempKey I

REPLACE;
iTempKey WITH RECNO()

*do your work

ALTER TABLE YourTable DROP COLUMN

HTH
Agnes
>Hi
>
>When you use recno() in select statements, is it reliable?
>
>In some old Fox2.6 apps we have duplicate keys and I need to differentiate between them.
>
>Thanks
>Kev