Re: Sorting on a partial email address

From: catcher@xxxxxxxxxxxxx (Robert)
Date: Wed, 20 Jul 2005 08:15:00 -0400

"pDale" <pdalec@xxxxxxxxx> wrote in message
news:5494c3ae05071816175d28e31f@xxxxxxxxxxxxxxxxx
On 7/18/05, Robert <catcher@xxxxxxxxxxxxx> 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 spread*** 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

.

References:
- Sorting on a partial email address
  - From: Robert
- Re: Sorting on a partial email address
  - From: pDale

Prev by Date: Re: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
Next by Date: panic: DBI active kids
Previous by thread: Re: Sorting on a partial email address
Next by thread: RE: Sorting on a partial email address
Index(es):
- Date
- Thread