Hi, Robert !

Robert martin wrote:

>The Coalesce stuff works great
>
>Coalesce(A, B, C) AS DispText
>
>However what if I want to order by this field ? Is this possible, or am I missing something?
>
>
>Rob Martin
>Software Engineer
>
>phone 03 377 0495
>fax 03 377 0496
>web www.chreos.com
>Wild Software Ltd
>
>

User order by "field position", like this:

Select Name, Price, Coalesce(A, B, C) from MyTable order by 3

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br