>>>Right, thanks. Still need to remove ; if we use the original code, though, and want to be able to run this select in command window first.
>>
>>Naomi,
>>While you need to remove ;
>>Just write your example without ;
>
>Because I want to be able to copy the select into the command window and run it.
Hi Naomi,
The question in this thread was:
Can anyone help me explain why this does not work?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.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst