LIKE with CASE SPECIFIC in Teradata

LIKE operator is not case sensitive in Teradata SQL.

Consider the following example,
SELECT empname FROM tbl_emp WHERE empname like '%JO%’;

The above query will pick values matching with 'JO' and 'jo' as well, since Teradata is not case-sensitive.

To overcome this problem, a new function called "CASESPECIFIC" is used in TERADATA as follows:
SELECT empname FROM tbl_emp WHERE empname (CASESPECIFIC) like '%JO%’;