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
>>Daniel,
>>
>>Thanks for the info. That is getting closer. However, this solution has problems when the lcList has comma-delimited values that are greater than single digits.
>>
>>For example, the following lcList string:
>>
>>lcList = ['100','101','102','103']
>>
>>Returns the following result set:
>>
>>iCustomerId
>>===========
>>1
>>2
>>3
>>10
>>100
>>101
>>102
>>103
>>
>>Do you have any other tricks up your sleeve or a modification to the above?
>>
>>Thanks again for your help!
>>
>>
>>>James,
>>>Assuming that your backend is SQL Server, the following should work:
>>>

>>>lcList = ['1','2','3','4']
>>>lcCmd  = 'select cname from customers where CHARINDEX(RTRIM(CAST(icustomerid as char(20))), ?lcList)>0'
>>>? sqlexec(lnHandle,lcCmd)
>>>

>>>It's a bit of a hack, but it works :-)
>>>The CHARINDEX() function is similar to VFP's AT() function and returns the starting position of the specified expression in a character string.
>>>
>>>HTH
>>>>I'm having difficutly using the IN operator in the parameter statement in a remote view against a SQL Server table. Here is my view:
>>>>
>>>>CREATE SQL VIEW "V_CUSTOMERS" ;
>>>> REMOTE CONNECT "My_Connection" AS ;
>>>> SELECT ;
>>>> Customers.icustomerid,;
>>>> Customers.cname,;
>>>> Status.cstatus ;
>>>> FROM Customers ;
>>>> LEFT JOIN Status ON Status.istatusid = Customers.istatusid ;
>>>> WHERE CAST(Customers.icustomerid as CHAR(20)) IN (?vp_cCustomerIdList) ;
>>>> ORDER BY Customers.cname
>>>>
>>>>I tried performing this same operation using SPT in the following statement:
>>>>
>>>>lcList = '1,2,3,4'
>>>>lcCmd = 'select cname from customers where cast(icustomerid as char(20)) in (?lcList)'
>>>>? sqlexec(lnHandle,lcCmd)
>>>>
>>>>I have tried changing the parameter (lcList) to the following without success:
>>>>
>>>>lcList = ['1','2','3','4']
>>>>
>>>>If I don't execute this as a parameter, then it will work:
>>>>
>>>>lcCmd = 'select cname from customers where cast(icustomerid as char(20)) in (' + lcList + ')'
>>>>? sqlexec(lnHandle,lcCmd)
>>>>
>>>>I really need to set this up as a parameterized view. Is there something that I am missing here or is what I am trying to accomplish just not work?
>>>>
>>>>Please help! I really would appreciate it.
>>>>
>>>>TIA,
>>>>
>>>>James