Teradata by default is case insensitive. Whatever value you compare in the WHERE clause it does not match the exact case of that value. So what if there is a scenario when you want to compare the value along with its specific case in the WHERE clause. Here come the CASESPECIFIC keyword for the rescue.Just …
