I have a macro substitution in an SQL statement as:

SELECT &gcSelect FROM ....

The SQL is bombing because the string being used in gcSelect is 391 characters long. Is this a limitation on macro subs in SQL or is this a limitation in VFP itself. I notice that if I try to evaluate the variable gcSelect in the debugger, it is truncated. Again, didn't know if this was a limitation on the watch/locals window or VFP itself.

Any thoughts?