| Subject | Order By Alias? |
|---|---|
| Author | dhay@lexmark.com |
| Post date | 2003-10-13T20:25:16Z |
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
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