Taco - Comes out like: ----------------------| Test data | ----------------------| New Course | fgs | fgsd | ----------------------|
In that order.. and we all know N comes before f... suuuure... Mark > Taco Fleur <[EMAIL PROTECTED]> wrote: > > 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/ -- ICQ: 3094740 [EMAIL PROTECTED] --- 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/
