>I am building a select statement for SQL and they can be long.
>
>How do I store a string longer than 254 into a memory variable??

The limit is 8192 bytes per any VFP command including SELECT statement. The TEXTMERGE allows to avoid problem with string literal limit of 255 bytes. See Re: Storing a SQL statement within a char variable Message #1038906