Sort email addresses after @domain.com

J

JohS

Hi. Anyone who know where I can find a sample of how I can make a query sort
after the @domanin.com (I need a dynamic elimination of the name before @)?
Thanks, JohS
 
S

Stefan Hoffmann

hi,
Hi. Anyone who know where I can find a sample of how I can make a query sort
after the @domanin.com (I need a dynamic elimination of the name before @)?
Click to expand...
Use

ORDER BY Mid(Nz(fieldName, ""), InStr(Nz(fieldName, ""), "@")+1)


mfG
--> stefan <--
 
Top