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/
