I believe it has something to do with the collation setting of your db. Try changing it at run-time to the correct collation i.e. SQL_Latin1_General_Cp1_CI_AS Where the CI stands for "Case Insensitive"
If this is not it, can you send some output of how the data is sorted? Hope it helps, Taco Fleur ----- Original Message ----- From: "Mark M" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, February 19, 2003 11:37 AM Subject: [cfaussie] [SQL] Order by on UNION > Hey all, > > Having issues on a order by with a union > > query looks something like this: > > -- > select * > from tableOne > > UNION > > select * > from tableTwo > > Order By tableColumn ASC > -- > > but I want it to be ordered by UPPER(tableColumn) > > i.e. > -- > select * > from tableOne > > UNION > > select * > from tableTwo > > Order By UPPER(tableColumn) ASC > -- > > As the order is going all wonky due to capitilization.... > > Is it possible to use function on a order by like that on a Union? > > If not, is there a possible workaround? > > Thanks, > > Mark > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
