I have the following select:

SELECT PADR("Activity",20," ") AS Name ,  99 AS Nomer FROM Funds  WHERE Kod == 1;
       UNION SELECT SPACE(20)  AS Name,   00 AS Nomer FROM Funds  WHERE Kod == 1;
       INTO CURSOR cAttr1

But the result cursor is ordered:

* I Expect
Name            Nomer
-------------   ------
"Activity   "       99 
"           "        0


*** The Result ????????????????
Name            Nomer
-------------   ------
"           "        0
"Activity   "       99 

I have no ORDER BY clause

There is no difference if I change the SELECT to this:

SELECT SPACE(20)                            AS Name,   00 AS Nomer FROM Funds  WHERE Kod == 1;
       UNION SELECT PADR("Activity",20," ") AS Name ,  99 AS Nomer FROM Funds  WHERE Kod == 1;
       INTO CURSOR cAttr1

TIA