I am having a problem with aliases:

In Paradox, the following works just perfect:

select field1 a, field2 b
from tablec
order by b;

In interbase I have to do it like this:

select field1 a, field2 b
from tablec
order by field2;

that's ok, but then again, this does NOT work that well:

select field1 a, field2 || ', ' || field3 b
from tablec
order by field2 || ', ' || field3;

uhm.. how do I get around this?