If you really want the first physical row in a table use WHERE COUNT = 1 Karen
-----Original Message----- From: Bruce A. Chitiea <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, Jul 1, 2013 12:45 pm Subject: [RBASE-L] - SELECT <First Row> All: RBGeX95(64) Current I want to hunt for certain strings within field 'humpty'. This works: DECLARE c1 SCROLL CURSOR FOR + SELECT humpty FROM wall OPEN c1 FETCH FIRST FROM c1 INTO vhumpty IND vind1 <Process> DROP CURSOR c1 Is there any direct means of SELECTing the FIRST row from table without having to resort to a cursor? Thanks Bruce Chitiea SafeSectors, Inc. eCondoMetrics 909.238.9012 cell
