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