I need to sort the domains of email addresses from right to left, so that all similar domains are grouped together. For instance, all .ca's will be in the same batch. I think I should be writing a trigger for this, using a secondary table for the reverse domain name, then using a query like: select email from table1, table2 where table1.oid=table2.id order by table2.reverse_domain; I'm not sure if keeping a secondary table is worthwhile, I will only be executing this query about 50 times per day. Let me know if there's a better way, Marc Tardif ************
