I am haveing a problem trying to extract files conatining ONLY the following from a field = @NY.COM

I have tried all forms of alltrim(), Right(), etc, but nothing sems to work...

here is my SQL Query code:

SELECT users.username, users.email;
FROM mytable!users;
WHERE alltrim(right(users.email,7)) = "@NY.COM";
GROUP BY users.username

Can anyone advise me where i am going wrong??

TIA