Try

SELECT users.username, users.email;
  FROM mytable!users ;
  WHERE users.email LIKE "%@NY.COM" ;
  GROUP BY users.username
* or
...
  WHERE users.email LIKE "%@NY.COM%" ;
...

>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