Ahhh...found it - with Ordinal number, right?!!

Cheers,

David




dhay@... on 13/10/2003 04:25:16 PM

Please respond to firebird-support@yahoogroups.com

To: firebird-support@yahoogroups.com
cc:
Subject: [firebird-support] Order By Alias?



Is it not possible to use ORDER BY on an Alias?

eg SELECT DISTINCT substring(UpperTitle from 1 for 1) AS firstLetter FROM
forms WHERE Available=1 ORDER BY firstLetter

If not, does anyone know how to achieve this another way?

Cheers,

David





To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/