Sergi -- your suggestion works perfectly, thank you! Now, when you say "current behavior of rownum in h2 is incorrect", are you saying it should it should assign the row numbers after the ordering, as per my original post? But in any event, I'm back on track and thanks again for your help...best regards...TerryG
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
