How to get Case Sensitivity in Teradata

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 by adding this keyword after the value in WHERE clause we can force the Teradata to impose case sensitivity on the checking condition

Here are some example to understand it better –

1.) SELECT CURRENT_DATE

WHERE

UPPER(‘teradata’) = ‘teradata’ (CASESPECIFIC); —- This Query will not return the current_date

2.) SELECT CURRENT_DATE

WHERE

LOWER(‘teradata’) = ‘teradata’ (CASESPECIFIC) —– This query will return the current_date

3.) SELECT emp_name

FROM emp_table

WHERE emp_name (CASESPECIFIC) LIKE ‘John%’ —— This query will return all name starting with capital J only

So just by using CASESPECIFIC we can force Teradata to check for case sensitivity