>>>The answer is
>>>while the string is more then 254 charachters.
>>>Every can give specific example to solved this problem.
>>>Not only copy and paste.
>>
>>What is your point? Yes, you can not have a string literal more than 255 chars and you can not have a macro more than 8192 chars.
>
>Check Message # 1216873
>Because I want to be able to copy the select into the command window and run it.

I still don't understand what you're saying. I guess someone writes a SQL in the command window, tests it, then wants to move it to the program to run as a string using macro. If that's the case, that someone needs to use TEXT/ENDTEXT construct and remove ; from the resulting string.