1. You shouldn't use INLIST in a query. Use IN operator instead. I don't think it has the same limitation as INLIST() function in VFP.
I don't think there is a limit ON IN list in SQL Server.
2. Yes IN operator can be optimized by SQL Server QP.
>
>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.
--sb--