Paul - Thanks for the reply,
Very similar work around I've got running atm. using lower(columnname) as columnname, and then using css "text-transform : capitalize" to stop it from looking dead ugly. So that DOES work... just not ideal. Was trying to stick with the original formatting, if at all possible. Cheers, 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/
