Forcing CASE SPECIFIC in Teradata

Teradata is by default case insensitive.
You can force to see the case before any comparison.

Example: (Without CASE SPECIFIC)

SELECT 'MATCHING'
WHERE
'HELLO' = 'hello'


Output:
'MATCHING'


Example: (With CASE SPECIFIC)

SELECT 'MATCHING'
WHERE
'HELLO' = 'hello' (CASESPECIFIC);


Output:
No output