Hi All,

I can't figure this one out...

This command doesn't work:

SELECT 'Sold' as Dataset,* from sold ;
       UNION select 'Mailed' as Dataset,* from mailed ;
       ORDER BY cRow INTO CURSOR temp

This command DOES work:

SELECT 'Sold' as Dataset,* from sold ORDER BY cRow INTO CURSOR temp

VFP 8 is telling me that the error is in my Order clause. The data in cRow is a number range (i.e. ' 700 - 799') right justified to 25 characters. The desired result is to combine the two cursors (output from the XTab FFC) and order by cRow (number range) and Dataset. If I don't use cRow and just use Dataset the query executes fine, its just the cRow for some reason.

Thanks in advance for any help.

Aloha,

James