Mike,

The column I'm interested in to populate the list box is unique, just not indexed on. So I can't do < or > columnX.

Is there a way to query in SQL Server using the record number? I think that would work for me.

Also, if I use FetchSize in conjunction with FetchAsNeeded, will that cause VFP to only retrieve next 10 records when I ask for next 10?

Thanks,

Pf

>I don't think that the FetchSize property will solve your problem. FetchSize determines the number of rows that VFP wait to receive before releasing to the program and retrieving the rest in the background.
>
>Is there anything in the table that even close to unique? You may be able to use the TOP command to limit the return results to 10. For example:
>
>

>LOCAL lcCompany, hConn, lnResult
>
>hConn = SQLCONNECT(...)
>lnResult = SQLEXEC(hConn, ;
>  [SELECT TOP 10 company FROM customer WHERE company > ?lcCompany ORDER BY company], 'c_companylist')
>