Mark, Have you considered using SELECT lower(columnname), columnname FROM ...? It's a bit inefficient because it pulls data twice, but it should work imho...
it's also an untested idea as I'm at MXDU too... Cheers Vik --- PS: Cheers for the wireless link Geoff > 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/
