Probably more than one solution here, but one possibility using your syntax is to try:

WHERE right(alltrim(users.email),7) = "@NY.COM";

as long as the email address actually ends in the pattern you indicate.

Bill


>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