Mel, try
SELECT MyTable.Last AS Last, MyTable.First AS First ;
ORDER BY UPPER( Last ), UPPER( First ) ;
INTO TABLE THISFORM.MyTableFolder+'MyTable'The data will be sorted by UPPER but not converted to uppercase - I think :) Although I am not sure why your original statement would not work. It looked ok to me? What was the error message?
Update: Sorry mine will not work. I think your orignal statement should work. What was the error message?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
