SQL Order By weirdness

Does anyone recognize why this list seems Out of Order? I am getting an odd result when using a calculation as the argument of an ORDER BY Statement... cfquery name=Hist SELECT Starts, Rejects FROM History ORDER BY ((Starts-Rejects)/Starts) /cfquery cfoutput query=Hist tr

RE: SQL Order By weirdness

Try putting the ((Starts-Rejects)/Starts) in your select list, give it an alias, and order by that alias -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 02 April 2002 10:33 To: CF-Talk Subject: SQL Order By weirdness Does anyone recognize why this list seems