Sorry. I'm disturbing your. I have a question about conversion of SQL Server Query to Teradata Query about LEFT function.
If anyone can help me in conversion of query to teradata;
CASE WHEN ( LEFT (COLUMNNAME,2) <> 60 AND COLUMNNAME2 IN (1,2)) THEN 2 ELSE 1 END )
I tried with Substring function. But I give syntax error.
By the way, Column Data Type: varchar(5)
Thanks in advance.
You don't give DDL's, your attempts and the errors you get, but
WHEN (SUBSTR(COLUMNNAME,1,2) <> '60' AND COLUMNNAME2 IN (1,2))
ELSE 1 END