General information
Category:
Coding, syntax & commands
Title:
Useing the RIGHT() command
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only