>>>>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.
Or, easier, execscript(TheString).