>What is the maximum length of an SQL select statement?
>
>and...
>
>Is there an easy way around it?

According to foxpro help the Maximum # of characters per command line is 8,192. The workaround is to use macro substitutions. Each macro substitution is limited to 8,192 characters.