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?