"pDale" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
On 7/18/05, Robert <[EMAIL PROTECTED]> wrote:
> I am pulling out users (name + email) and I need to sort the list by
> everything after the @ sign in the email address. I wasn't sure which
group
> to post to.
>
> I am pulling them into an excel spreadsheet from Oracle. I wasn't sure at
> what point the sort should happen (except sometime before it writes to the
> xls). : )
How about:
SELECT eaddr
FROM db
ORDER BY substr( eaddr, instr( eaddr, '@')+1);
--
That was perfect! Sorry if this was in the wrong group.
Robert