I know that VFP will not perform substitutions within a string as
in
#define SUPERLATIVE better
sentence="Father knows SUPERLATIVE."
but is there a way to get a similar effect?

I use SQLSEL as in
#define SQLSEL select
...
SQLSEL clcode,clname from ccli order by clcode
to differentiate between xBASE select statements and SQL select
statements.

Occasionally, I need to build an SQL statement with a subquery in
it and would like to build the expression as in
wherecond=;
"&limitexpr and "+;
"trnnbr in (SQLSEL wonbr from cwko where woccode=currwocc)"
This does not work. I have to use "select" and make a note (so that
when I search for SQL select statements, I can find them all.

Any ideas?

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.