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


[Non-text portions of this message have been removed]