I needed to do a sql query and pick a column based on a variable. By trial and error I discovered the following worked.

select desc, co;
from lit;
where lit.afscme="X";
and lit.&vstate="X";
and eng="X";
and mbrpiece="X";
into cursor test

The use aof the & in front of the variable was pure luck.

Is there any place that describes the syntax for the use and assignment of vairables. It seems as if I am always running into this type of problem in using and declaring variables.

Thanks