Try putting your SELECT statement between TEXT TO ... ENDTEXT.

Also, a string length can be up to 255 but you can concatent multiples together like this

x = "a string that is 255 characters long"
y = "a string that is 255 characters long"

z = x + y
?Len(z) && 510

>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??