The code below is working when I use it in SQL Server database, but it gives me an error when I query Teradata.
Select * From Employees WHERE RIGHT(mail_cd, 2) in ('AB','AC','CD','FK')
The error message is "SELECT Failed. 3706: Syntax error: Expected something between the WHERE keyword and the RIGHT keyword"
How would I query Teradata for the same results?
Thank you for your help
Thank you fo