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