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