>>>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.
If it's not broken, fix it until it is.
My Blog