> 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?

ORDER BY 1

It uses column 1

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services