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