>
>1) Do not use inlist() bu in ().
>2) Unlike VFP you can send very long lists.
>3) As list size increases it gets slower (SQL server needs to consume a larger input)
>4) An alternative is to create a temp table on the same connection and insert values in that table then use a join (or in (select ... )). This approach works better if you are using the same query for both VFP and SQL.
>Cetin
Thank you, Cetin.
Although I don't understand how to do item 4) in your list. How do you create a temp table in SQL Server without a stored procedure?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham