>Max fields selected by SQL select = 255.
>Max # char's per command line, and subsequently, any SQL = 8192.
>
>This and other VFP Capacities in:
>support.microsoft.com/support/kb/articles/Q129/6/32.asp

Bob and Jim,

The way to get around the command line limitation is:
cMySelect = [SELECT ... ]
cMyFrom = [FROM ... ]
cMyWhere = [WHERE ... ]

cMySQL = cMySelect + cMyFrom + cMyWhere
&cMySQL
This also allows me to repeat the cMyFrom in more than one selection.