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/
