Hi Matthew,
>If I want to build a more complex select statement and store it in a string, then how do I execute it?
You could use the & to execute strings
&lcSQL
or
If you end up building multiple strings you could also use
&lcSelect &lcFrom &lcWhere