Hello Dmitry!
I want to thank you and Ann for your answers. But it appears to be that: "select "TESTID", "NAME" from test order by upper(2)" and "select "TESTID", "NAME" from test union select "TESTID", "NAME" from test order by 2" are valid queries and "select "TESTID", "NAME" from test union select "TESTID", "NAME" from test order by upper(2)" is an invalid query because of the use of upper() in the "order by" clause. I was hoping for a simple solution to solve this but now I have to test with a custom case-insensitive collation. Regards, Roy Damman
