Randy

A couple of things that may be the problem. Referencing an alias in a sql select is not a good idea since the alias used in the SQL is not necessarily and in this case probably will not be 'myDBF' in the select execution. Also you will have use macro expansion in the where clause. If you simply macro expand your original where clause, it will probbly return all records since work area "myDBF" is already on myRecno and the where condition will evaluate to .T. for each record in the select.

Try this

USE myDBF
myRecno = recno()
*!* notice that I removed the recno() alias parameter 
lcFilter = "recno() = myRecno"  && myRecno is only variable
SELE * FROM myDBF WHERE &lcFilter