Hi Richard,
>As far as I can tell SQL-SELECT doesn't support ORDER BY ASC for TOP 'n' queries, just DESC. Is there any way to simulate BOTTOM 'n' in a VFP SQL-SELECT line such as:
SELECT TOP 'n' field1 FROM mytable WHERE field1 < lnmyvariable ORDER BY field1 DESC
This may seem like a long shot but maybe there is there a cunning function known only to UT subscribers which inverts character, date or numeric values...worth asking anyhow.
If its a numeric, you could experiment with multiplying everything by -1, then the order will be reversed.