>How do you look at a SQL statement that has macro substitution in it before it executes?

If you have some concerns or get errors, than you can just check macros part in messagebox:
cMacros="Where .T."
=messagebox(cMacros)
Select * From Table1 &cMacros.

BTW, you can collect whole command line and look at it and\or run as macros:
cCommand="Select * From table1 "+cWherestring
*** check cCommand in Debug window or using messagebox
&cCommand.