Ian :
>> Here is a snippet of code which will set you right: SELECT COUNT(*) INTO vcount &vwhere AND LIMIT = 201 << May I ask a question about your LIMIT clause ? What is it supposed to do : 1) Limit the selection to the first 201 row of the table ? or 2) Look thru the entiere table and take only the fisrt 201 row that fit the WHERE clause ? TMHO answer (1) should be the rigth one but now I am not sure anymore .... J.M. GRATIAS, Logimatique ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
