Randy,
I forgot to mention that the ORDER BY clause in UNION SELECT can only reference columns by number not by name. Anyway UNIONless solution is simplier.
SELECT "1" AS so, part_no As so2, * ;
FROM bondmat ;
WHERE stores ;
UNION ALL ;
SELECT "2" AS so, * FROM bondmat ;
WHERE .NOT.stores
ORDER BY 1, 2 ;
INTO TABLE rcursor
>Sergey-
>
>Thanks for your prompt-as-usual help.
>
>The revised statement gives me the same error; it still complains that the Order By clause is invalid. What I was trying to do was group all the 'stores' items in part_no order before all the 'non-stores' items also in part_no order.
>
>The statement w/o the UNION resembles what I used for my index tag. I changed the Order By clause to "so, part_no" and got my desired results. I'll have to slay the UNION dragon in another SQL encounter. ;-)
>
--sb--