Sort by Email Address

hello,
i have application want sort email address url ( right of @ ) , still want display full email address. there question similar not answered in format use. using access database.

my query

<cfquery name="getemails" datasource="#application.db#">
select email_id, email_address
from email_out
order email_address
</cfquery>

i have tried listlast(email_address,"@") in sql statement can not work.
i have tried listlast(email_address,"@") in query output print out right part of email address, not quite want.
i want have query output of information sort text right of @

i.e. janet@wpxdesign.com
jim@wpxdesign.com
wayne@wpxdesign.com

so if did not throw error need -

<cfquery name="getemails" datasource="#application.db#">
select email_id, email_address
from email_out
order listlast(email_address,"@")
</cfquery>

but doesn't work tried select email_id, listlast(email_address,"@") daemail

but didn't work either

thanks in advance.

this depends on whether or not db has enough string functions. here how it's done redbrick. you'll have read manual own software see if there equivalent functionality.

order
substr(email_address,
position('@', email_address) +1,
length(email_address) )

More discussions in Advanced Techniques

adobe