Actually, I am dealing with ORACLE.

>Timothy,
>If your dealing with SQL Server, try the following statement:
>

>SQLExec(lnHandle,"SELECT * FROM amcs_inventory_data where CHARINDEX('" + svar + "', location) > 0","Result1")
>

>
>CHARINDEX() is very similar to VFP's AT() function.
>
>HTH
>>>>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 ). "