Is Like comparison case-sensitive in Teradata?
LIKE operator is not case sensitive in Teradata session mode.
Consider the following example
Select F_name from employee where F_name like '%JO%’;
The following 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 F_name from employee where F_name (CASESPECIFIC) like '%JO%’;