>>>Is there some reason why the below statement does not work if I include svar?
>>>
>>>svar='RM 113'
>>>SQLExec(lnHandle,"SELECT * FROM amcs_inventory_data where;
>>>svar $ location","Result1")
>>>sele result1
>>>brow
>>
>>Try:
>>
>>
>>SQLExec(lnHandle,"SELECT * FROM amcs_inventory_data where " +;
>> "'" + svar "'$ location","Result1")
>>
>>Although I don't think the $ operator would be supported through the ODBC driver.
>
>I tried this and it comes back with "Function name is missing ). "
It is because the $ operator is a VFP operator. Is this SQL Server data? How about:
lcSql = "select * from buyers where charindex('" + ;
svar + "',location) > 0"
SQLExec(lnHandle,lcSql,"Result1")
Steve Gibson