I don't have Oracle handy now. Please try my example (or similar) and see what it returns. I anything, the results of SQL queries should be predictable .



Dragi "Bonzi" Raos
Zagreb, Croatia
Q#5196, MkII#80000376, 18GB green
_________________________
Dragi "Bonzi" Raos Q#5196 MkII #080000376, 18GB green MkIIa #040103247, 60GB blue