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