On Tuesday, August 5, 2008 at 4:18:48 PM UTC+5:30, Robert Welz wrote:

Laurenz Albe <inv...@spam.to.invalid> wrote:
...

SELECT * FROM (SELECT * FROM a UNION SELECT * FROM b) dummy
ORDER BY upper(val);

id | val
----+-------------
1 | one
1 | ONE HUNDRED
2 | two
2 | TWO HUNDRED
(4 rows)

There you go!

Yours,
Laurenz Albe

Great! Thank you very much!
Robert

...........................................


Great solution!! Thanks - Laurenz Albe . IF you ever be to India (Tamilnadu). your beer's on me.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)