Partial answer Dmitry
Both vfp and sql server
select * from mytable where ( keyfldname in ("val1", "val2", "val3"))
_____________
>Good morning,
>
>Using SPT from VFP 9 I need to retrieve a bunch of records from a table in SQL Server. The know information is a key field values for each of the records. So I am thinking of building an expressing that will use INLIST() as following:
>
>
>cSqlCommand = "select * from mytable where
>inlist( keyfldname, 'val1', 'val2', 'val3 )"
>
>
>I have 2 questions:
>
>1. VFP help says that the number of INLIST expressions can be up to 25. Is this the same in SQL Server?
>
>2. In VFP INLIST() is Rushmore optimized. Is this the same in SQL Server (if index on KEYFLDNAME exist)?
>
>Thank you in advance for your help.
Gregory