>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.
You're thinking about IN (). There is no INLIST() in SQL Server, AFAIK.
You can include unlimited number of parameters in IN () and they are Rushmore optimized (SQL Server also optimizes it).
If it's not broken, fix it until it is.
My Blog