cSQL = [SELECT employee_queue_schedules.cTrans_Employees_Queues_fk]+;
[ FROM Employee_Queue_schedules]+;
[ WHERE cTrans_Employees_Queues_fk in (]+vp_list+[)]

nStat = SQLEXEC(nHandle,cSQL,"YourCursor")

>In VFP8 it works with
>SELECT employee_queue_schedules.cTrans_Employees_Queues_fk FROM Employee_Queue_schedules WHERE cTrans_Employees_Queues_fk in (?&vp_list)
>
>But I don't want to use macro. If I switch to SQL Server, how should I make the same select command to work?
>
>>>Hi everybody,
>>>
>>>This command works in the Command Window:
>>>
>>>

SELECT employee_queue_schedules.cTrans_Employees_Queues_fk ;
>>>FROM Employee_Queue_schedules ;
>>>WHERE cTrans_Employees_Queues_fk in ('A4D','A4C')

>>>
>>>However, I don't see a way to use ('A4D','A4C') as ?vp_List
>>>
>>>Do you know, how can I make it?
>>>
>>>Thanks in advance.
>>
>>

>>....
>>WHERE cTrans_Employees_Queues_fk in (&?vp_List)
>>
>>vp_List = ['A4D','A4C']
>>=requery()
>>