Paul -
Thanks for the reply.
Very similar to the workaround I have currently in place.
using lower(columnname) to ensure that ordering happens the way I want it to,
then utilising CSS ('text-transform : capitalize') to make the displaying text show
up not looking funny.
Not the ideal way, but it does work :oP
Mark
> [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> On Wed, Feb 19, 2003 at 12:37:26PM +1100, Mark M wrote:
>
> > 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
>
> Untested, but try:
>
> select upper(tablecolumn) as upfield, *
> from tableone
> UNION
> select upper(tablecolumn) as upfield, *
> from tabletwo
> order by upfield asc
>
> What's happening here is that you're extracting the upper
> cased field as a new field, then ordering on that new field.
>
> You might find you have to refer to the field by number,
> rather than name. eg:
> order by 1 asc
>
> Cheers from MXDU
>
> Paul Haddon
> Technical Services Manager
> Formstar Print Technologies
>
>
>
> ---
> 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/
