Subject Re: [firebird-support] SQL Text joining
Author Robert martin
Hi Alexandre

That works great, I should have considered that as an option.

Rob Martin
Software Engineer

phone 03 377 0495
fax 03 377 0496
Wild Software Ltd
----- Original Message -----
From: Alexandre Benson Smith
Sent: Friday, November 05, 2004 10:25 AM
Subject: Re: [firebird-support] SQL Text joining

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
>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
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil

Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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