Hmmm,
In this case check the value of m.lcListOfPKs.

>Thanks Vladimir, but as far as I can tell I am not getting any error, it's just not returning all the records I expect.
>
>>Hi Frank,
>>1. check with AERRROR() function
>>2. take a look in SQL Help "in keyword"
>>
>>and
>>Take a look at
>>www.support.microsoft.com/kb/913050
>>
>>>Hi,
>>>
>>>I've been using a SQL query that uses a list of primary keys as a parameter to bring out all those records that a user selected.
>>>
>>>The logic I use is:
>>>
>>>User selects a bunch of records in a grid/cursor, I build up a list of all the primary keys (PKs) selected and pass this list to a method that builds up an SQL command using:
>>>
>>>WHERE clm_pk IN (?m.lcListOfPKs)
>>>
>>>The user has reported that when they select a large number (2000 odd) the result does not include all selected and seems to stop at a particular count (1800 odd). Is there a limit of how many items SQL server will use in an IN clause? Or maybe this is a VFP limit in terms of how long the string that I build up with the list of PKs can be?
>>>
>>>Is there any other/better way to pass a list of Primary Keys from VFP to SQL Server in order to limit a result set?