James,

Are the numbers you're after stored as numeric or character?

How will they be input? How many will there be - 10? 100?

Can you put them in a table and do an inner join from your local table to your remote view?


>Daniel,
>
>I still get the same result. Is there something I'm missing? I copied your code exactly and still get the same result set.
>
>Thanks for your assistance.
>
>>James,
>>Simply add the comma (or any other separator) to the search expression. Make sure that lcList terminates with the separator:
>>

>>lcList = '100,101,102,103,'
>>lcCmd  = 'select cname from customers where CHARINDEX(RTRIM(CAST(icustomerid as char(20)))+',', ?lcList)>0'
>>? sqlexec(lnHandle,lcCmd)
>>

>>HTH