Tom,
A string constant in VFP can not exceed 254 characters. ie "you can not put more than 254 characters in between quotes"
A string variable can contain megabytes of data.
If you have to work with long blocks of static text build them from smaller string constants:
lcSelect = "select ......" + ;
" from ....." + ;
" where ....."
SQLExec( lnConnection, lcSelect )
>I'm trying to pass a string to sql with a length of 500. VFP truncates my string to 254. How do I pass the whole string?