Karen/Tony:
Thanks much. That'll do just fine. I'm really just looking for the first physical row, whatever it is. I admit to making a questionable assumption that the string I'm looking forward is in that row; an assumption rendered less foolish by the "reliable" automated routine which created the Excel data being Gateway'd into this table. If the string ISN'T there, I've got OTher problems. Bruce From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Monday, July 01, 2013 10:57 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SELECT <First Row> If you really want the first physical row in a table use WHERE COUNT = 1 Karen -----Original Message----- From: Bruce A. Chitiea <[email protected] <mailto:[email protected]> > To: RBASE-L Mailing List <[email protected] <mailto:[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
