Hello.

Is it possibly to sort a query using a calculated variable? Let's say I have a table with the following fields. Name, Number1, Number2. What if I want to display all 'Name' values sorted by Number1 + Number2 (sorted by their sum) or perhaps Number2 / Number1. Is that possible? And how would I do that?

Thanks,
- shazow

Try:

SELECT field1, field2 FROM table ORDER BY field1 + field2

or:

SELECT field1, field2, field1 + field2 as field3 FROM table ORDER BY field3

TheStone.

B.

Thank you very much! It worked perfectly.