Sort email addresses after @domain.com

[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

 

[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 @)?

Use

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


mfG
--> stefan <--