I have one more SELECT-Sql question that perhaps someone can help me with.

I would like to ORDER by a last name and first name field. However, I need this in upper case so they order correctly. Is this possible? or do I just need to index the result of the cursor?

I did something like:

SELECT ALLTRIM(UPPER(MyTable.Last)) AS UpperLast, ;
    ALLTRIM(UPPER(MyTable.First)) AS UpperFirst ;
    ORDER BY UpperLast, UpperFirst ;
    INTO TABLE THISFORM.MyTableFolder+'MyTable'

which doesn't work.

Thanks for the help.

Mel Cummings