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 ). "