Subject Re: [IBO] "order by coalesce" problem
Author Lester Caine
Matej Golob wrote:

>>if you change it to
>>select coalesce(field1, field2), * from table order by 1
>>it should work ok
> Yes, this works. But it's just workaround for the problem. Thanks anyway.

Depends how you look at it. Since the order details are now a proper
field, they can be used or displayed if required.
So is the other way actually needed?

Lester Caine
L.S.Caine Electronic Services